Thank you so much for taking the time to read and respond to my questions.
I have a weekly schedule for multiple locations. Each location has different amount of employees assigned. Each day could have a different number of employees and various shifts. An employee could be assigned to location A today and Location B tomorrow.* Plus they could do 2 shifts today at Location A or work at 2 different locations in one day.
Column A: location (10+ different locations)
Column B: date (Monday date)
Column C: employee (select from dropdown on different worksheet)
Column D: Time shift begins
Column E: Time shift ends
Then Columns repeat pattern, F: location, G=date (Tuesday date)....goes across for total 7 days in this pattern.
Example - first location could have 5 employees on Monday, 3 on Tuesday, etc. Each day could have different shift times.
No one location has same number of shifts, employees, or times in and out.
On Monday John could be at Location ABC from 1 pm to 9 pm, on Tuesday he could be at another location with different shift. So John's name could be on row 10 for Monday and row 33 on Tuesday.
I can print out for myself a Master document to manage staff using this view. But for staff I need to have each employee in first column and their shifts and locations to the right by day.
Example:
John- Location Monday 1pm - 9pm Location Tuesday 2pm - 10pm, etc.
Then below John would be Fred and his schedule...all employees on one view.
Any given day I can have up to 100 employees or as few as 25.
I have it setup like this on order to provide Payroll company a CSV file.
I tried a Pivot table and it was messy (very badic pivot table skills).
Thought about a Vlookup...don't know enough to know if that would work.
I'd appreciate any advice. *
Thx, m
