Filter cell C5 according to header selection in cell B5

[chatnet26]

Dear Guys,

I have an excel form which use to follow up a tracking sheet in our company specially the training of employee around 1,500 employees. I wanted to come up a result to lessen my daily activities. I use to do filtering but lately I think it will make me more effective in doing the monthly reporting. Here is the question:

In sheet 1 a have list of all section heads and people who are reported directly to them. In sheet 2 cell B5 is a list of sections heads. In cell C5 a list of group employees who are directly reporting to each section heads. I wanted to come up a result that when filtering cell B5 it give a result of peoples in cell C5 who are reported directly to him instead of filter and unfilter one by one.

I hope someone can help me out.

Appreciate your kind support on this request.

Thanks and Best Regards,
John

 

[NARAYANK991]

Hi ,

You can get help quicker , and probably help which will be to the point , if you upload your workbook containing enough data.

Narayan

 

[chatnet26]

Hi Narayan,

Please see attached item. As you can see in sheet 2 section heads name is being repeated just to get the members of his group. Instead, I don't want to repeat typing his name until his last member just to get his groups. I wanted to look the table in a professional way in which I filter his name I should get his groups.

Thanks and Best Regards,

 

[chatnet26]

Dear Gentlemen,

I am hoping that someone could figure out.

Thanks and Best Regards,

 

[Nebu]

Hi:

Find the attached.

Thanks

 

[chatnet26]

Dear Nebu,

This is excellent idea and a useful tool. Thanks for a great job. really I am a beginner in excel however this is exactly what I am looking for. After several reviews on how it works I figured out thru on the tool tab tips of excel it is called Pivot table. This is amazing.

Again, many thanks indeed.

Thanks and Best Regards,