Selecting names based on Teams (using dropdown)

[maximpinto]

Hi,
I have a sheet attached wherin i would want to use macro features to the minimal but if needed then i can go ahead with them.

This is like a master list to me wherein in one shot i should be able to see data regarding the shift details of employees. There are about 14 employees, but can extend to 60
These employees could fall into different departmetns
As mentioned in Row8(D8,E8..)
I send this out as a common template to the team leaders of these teams.

My question is at D2 i want a dropdown containing group names (DBA,NSS,BSS,SMC..).
So when a team lead receives this sheet and when he selects from the dropdown for ex DBA only those columns of employees who belong to DBA should appear.
Once they fill and send it back, for me it should be easy to simply copy them.

In the dropdown i also want an option called "All" so that when all is clicked all the resources appear but should be sorted based on teams like first DBA resource,BSS resource etc..

At first i want to achieve this so that i can proceed futher.


Note: I do know that if i did a transpose of days and resources i could filter on teams, but i need to update other system seeing this data and so the column view for each resource would be easier for me

Many thanks
max

[Bob Phillips]

See http://www.contextures.com/xlDataVal02.html

[maximpinto]

I am going no where with that though it explains well. Can you please do that for my sheet
thanks
max