Selecting names based on Teams (using dropdown)

[max]

Hi,

The excel sheet is at
[http://www.4shared.com/file/136709270/209bb11/ITOpsShiftData.html
]
In the sheet attached i would want to use macro features to the minimal but
if needed then i can go ahead with using macros.

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

 

[max]

Dear P45cal,
Amazing!!!!!!!!!!!!!!!!! I have no words to explain your expertise, thanks
a lot.
Well that part is working fine now.
I just have to achieve one more thing. From D10toR39 as in this sheet. I
have actually the shift data. Well i have 2 questions here.
1> When user chooses from Dropdown "vacation,Off Day,Holiday the cell
colr shold be white. When General i want one color, when ITOps-2ndshift i
want cell to change color when selected...

2> i tried placing a text box on the top near D1 to G1 to explain the time
Like General: 08:00 - 17:00 "Color"
but due to freeze panes that will not be visile to user i want it to
stay there regardless of we move columns. How can i do this or any other way
to show that details in the same sheet. Please suggest
Thanks again for your time
Max

 

[max]

Thanks for your inputs have done them.
One last thing i got to ask
When i select "All" from the dropdown, the columns appear in teh form
entered , randomnly.
Is there a way that when "all is selected" i get the Teams ordered(sorted)
like all CTS,then all DBA, ...
Thanks again
Max

 

[max]

Thanks a ton for all that you did to me on this topic
thanks
max

 

[max]

Dear p45cal,
I am back with the same sheet.I have achieved all with your help but now i
had applied conditional formattingfor the cells to choose shifts. but for
2003 users they would not be able to see all coloring. How can i go about
this now, is there a way to fix this.
Also in the excel can i make the cell B2 to keep blinking/flashing to draw
users attention
my file is at link
http://www.4shared.com/file/137908114/75b96b76/Working.html

Thanks
max

Thanks a ton for all that you did to me on this topic
thanks
max