OK everybody here is my issue. I make the schedule for my job and keep track of the employees that do not have a set schedule. I need a way to be able to each employee their schedule only. I used vlookup and other function to help me otimate this but I have gotten mixed feedback about the format. I finally found a format that everyone can agree on but I have no idea how to get it started.
I attacked a sample so that you can take a look. Basically I need to be able to change the dates on the individual schedule and have excel give me (from the master schedule above) the post, start and end times the employee I type in will be working that week.
I’m comfortable with most lookup function but I really have no idea how to even get started. Any help would be greatly appreciated.
Bookmarks