Here's my dilema. I've attached a scheduler program we're working on in a simplified format.
Sheet 1 "Scheduler" is the comprehensive scheduling tool. I would like to be able to popluate sheet 2 "Schedule" based on input criteria of a specific date or preferrable a range of dates that will buildout the schedule for that day/week etc in a more usable format for the supervisors to know who is supposed to be at work and on what shift/function.
I've manually created what I want sheet 2 to look like but haven't a clue where to start parsing the data on sheet 1.
Bruce
Bookmarks