Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Point me in the right direction
I have a workbook with two worksheets. One worksheet contains
Supervisor information for vacation scheduling for his/her group The other sheet contains a list of all employees for the shop. There are 7 Supervisors with about 20 employees each. I use a data validation to a list to change the supervisor name on the sheet and and I want to be able to draw only his employees from the second worksheet and show their names in a range of cells on the first worksheet. Can someone point me in the right direction as to how I can accomplish this? I'm not even sure what to put in the search criteria to find any information on this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Point me in the right direction
ok lets see if i have this right. If you select the supervisors name you want
to see only their direct reports information which is stored on the second sheet? If thats right we have about a hundred options to accompish this. I would be happy to help. "Opal" wrote: I have a workbook with two worksheets. One worksheet contains Supervisor information for vacation scheduling for his/her group The other sheet contains a list of all employees for the shop. There are 7 Supervisors with about 20 employees each. I use a data validation to a list to change the supervisor name on the sheet and and I want to be able to draw only his employees from the second worksheet and show their names in a range of cells on the first worksheet. Can someone point me in the right direction as to how I can accomplish this? I'm not even sure what to put in the search criteria to find any information on this. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Point me in the right direction
Are you wanting to only show the names or the time off as well?
"Opal" wrote: I have a workbook with two worksheets. One worksheet contains Supervisor information for vacation scheduling for his/her group The other sheet contains a list of all employees for the shop. There are 7 Supervisors with about 20 employees each. I use a data validation to a list to change the supervisor name on the sheet and and I want to be able to draw only his employees from the second worksheet and show their names in a range of cells on the first worksheet. Can someone point me in the right direction as to how I can accomplish this? I'm not even sure what to put in the search criteria to find any information on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A point in the right direction... | Excel Programming | |||
Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
Need Direction | Excel Programming | |||
Can anyone point me in the right direction please? | Excel Programming | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel |