Need Some Help

[Pushppreet]

Hello,

I need some help with the attached file. My friend had created this file for me initially and now I want some changes to be done and I am stuck as he is on leave.

In the attached file, Worksheet 1 (Trng & Trainer Search) is working fine where when I put the training name or the trainer name the schedule reflects respectively. However in worksheet 2 (Monthly Search) I want that when I select the month, the complete data from sheet 3 (Calendar) of that month should get reflected in sheet 2 (Monthly Search).

Can someone please help me with this.

Thank you in advance.

Regards,
Pushppreet

 

[PCosta87]

Hi,

Welcome to the forum

Here you go... should work as intended.

 

[Syedali]

Hello,

I need some urgent help with the attached file. My friend had created this file for me initially and now I want some changes to be done and I am stuck as he is on leave.

In the attached file, Worksheet 1 (Trng & Trainer Search) is working fine where when I put the training name or the trainer name the schedule reflects respectively. However in worksheet 2 (Monthly Search) I want that when I select the month, the complete data from sheet 3 (Calendar) of that month should get reflected in sheet 2 (Monthly Search).

Can someone please help me with this as its very urgent and important for me.

Thank you in advance.

Regards,
Pushppreet

Hi,

PFA. Let me know if you have any clarification.

 

[Pushppreet]

Hi,

Welcome to the forum

Here you go... should work as intended.

Hey buddy,

Thanks a heap...! Really appreciate your help. Now I know whom to look for in future if I need any help like this...! You are a savior...!!!

Cheers

 

[Pushppreet]

Hi,

PFA. Let me know if you have any clarification.

Dear Syed,

Thanks a lot for your help. Really appreciate it..!

Regards,
Pushppreet

 

[PCosta87]

Hey buddy,

Thanks a heap...! Really appreciate your help. Now I know whom to look for in future if I need any help like this...! You are a savior...!!!

Cheers

Don't mention it... glad I could help

 

[Pushppreet]

Don't mention it... glad I could help

Hey,

I have a question, In the first worksheet, would it be possible to have 2 trainer / training search options... As in I select one trainers name and get a display and then I would like to have another row where I can search for another trainers / training under it without affecting the result of the first column..?

Have attached the file for your reference.

Thanks in advance.

Regards,
Pushppreet