transferring certain information from one spreadsheet to another

Pretty new to excel, and have a question about a spreadsheet I’m creating for work. I’m making a schedule for my employees and am trying to make the whole process a little easier on myself, so I’ll try to explain to the best of my ability.

The schedule I have now has employee names located on the Y axis with the days of the week running along the Y. A simple weekly schedule. So if someone is working on a Monday, it’ll say their shift time in the appropriate slot; IE 9-6….or like 9:30-3. If they are not working it’ll have an ‘x’ in the box. That’s the schedule I physically build every week and allot people hours based on how many hours I am given.

In another spreadsheet I have built a daily ‘Zone Chart’ that corresponds to each day. Along the X axis up top I have boxes for ‘name’ ‘shift start’ ‘shift end’ and then hours of the day which are highlighted for each individual employee based on the time they are working. When I type in a name and start/end time it highlights the appropriate time. Really basic. Here is my question though:

Is it possible to have this second ‘zone chart’ spreadsheet auto populate with employee names and start/end dates as soon as I make the original daily schedule? So if I fill out on a Monday that bill is working from 4pm-9pm, it’ll automatically transfer over those times to the other spreadsheet. Just one condition though, if someone is NOT working, how do I get the function to skip over their name, not even include them on the daily zone chart, and automatically go on to read the next employee. Basically this is for aesthetic purposes, as I don’t want to have someone who is not coming in to be on the daily schedule.

Does this question make sense? Let me know if you’d like me to elaborate on it. I’m kinda stuck and would love input!

Hey, this sounds simple enough, but would be a million miles easier if we had a sample workbook. Can you upload?

yea totally. here it is:

Thanks, working on this now for you. Should have it back tomorrow.

sample(1).xls

Here you go mate, best I can do, very messy code I know, Im a newb

Originally Posted by Steven8294

Attachment 206335

Here you go mate, best I can do, very messy code I know, Im a newb

Wow, good job. I wouldn't even know where to start with all this stuff. Dang. A couple things I will try to get to fix by myself. Thanks man.