M
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
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