capt_74_2000
New Member
- Joined
- Apr 25, 2002
- Messages
- 39
I have a list of employees in column 1.
I have days of the month covering a 6 week period of time across the top row. (starting in col 2)
If an employee is scheduled to work on a specific day (days) a number is placed in their row under the appropriate day of the 6 week period. (the number is 1-3, signifying shift 1,2 or 3).
On another spreadsheet, I want to be able to bring up a list of names of the employees who are scheduled to work for a specific day (a prompt for the date would be necessary). How can I accomplish this?
Thank you,
_Mike
I have days of the month covering a 6 week period of time across the top row. (starting in col 2)
If an employee is scheduled to work on a specific day (days) a number is placed in their row under the appropriate day of the 6 week period. (the number is 1-3, signifying shift 1,2 or 3).
On another spreadsheet, I want to be able to bring up a list of names of the employees who are scheduled to work for a specific day (a prompt for the date would be necessary). How can I accomplish this?
Thank you,
_Mike