I have a schedule I made, but I am having trouble getting the information to populate into the other 7 sheets. I would like to write the schedule on the schedule tab, and have the scheduled employees populate to the specific tabs. Ie monday, tuesday, etc. I was able to get the schedule to work, but I am having trouble with my limited excel knowledge to get the names and scheduled times to populate to the coresponding day. I am also trying to calculate daily goals based on hours worked on the floor between 10 am and 8 pm. So if someone is scheduled before 10 am, those hours arent reflected in the calculation.
For instance on the example sheet, I would like Sheila's name to populate in Sundays B25, then Natasha name in b26, and so on. Sheila would have 6 hours on the sales floor (open 11-5) , Natasha would have 6, and Patty would have 4.
I put all the info in the sunday tab, but can't figure out how to make it work from the schedule tab.
Thanks in advance for any help!
Bookmarks