Who's working on that Day ?

capt_74_2000 · Apr 26th, 2002, 01:01 PM

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

Tom Schreiner · Apr 26th, 2002, 04:59 PM

Hi
Mail me your sheet.
TsTom@HotMail.Com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 01:01 PM	#1
capt_74_2000 New Member Join Date: Apr 2002 Posts: 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

Apr 26th, 2002, 04:59 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Mail me your sheet. TsTom@HotMail.Com