clueless where to start.

  • Thread starter Thread starter qteekat
  • Start date Start date
Q

qteekat

I'm using 8 sheets in a workbook

Sheet 1 :

Col A= names of employess

col C-I = days of the week

I'm trying to find a function that will input the employee's name on sheet 2
when "4am" (is the time start) is typed under the day of the week they have
to work. Each day of the week will have it's own sheet. And i need it to put
the all the employe's name that has to work on that day to each separate
sheet that they work.

I hope that explains what I need. Thank you in advance.
 
very annoying voice, but you should learn a thing or two

I hope that dude isn't a teacher!
 
Okay. I learned a thing or two but still not working for me.

Sheet 1 looks like this


Monday Tuesday Wednesday Etc...

John Smith off 4am 4am
Katie Jones 4am 4am 4am
Dawn Moran 4am 4am off

etc....


I would like sheet 2 (renamed "Monday") to list the names with "4am" under
the column Monday. And not list the names with "off" under the Monday column.


So "Monday" sheet should look someting like

Schedule

Katie Jones
Dawn Moran
etc...
 
Back
Top