Generate a daily roster from a weekly schedule?

[chaz4070]

Hi all, this is my first post and I could really use some help on this one...

I write a weekly schedule with in times for an AM shift and a PM shift. The number of people on each shift vary from day to day and week to week. Weekly schedule looks like this:

Book1
	A	B	C	D	E	F	G	H	I
2			MON	TUE	WED	THUR	FRI	SAT	SUN
3			10/6	10/7	10/8	10/9	10/10	10/11	10/12
4	AMANDA	AM	11H	10:30	11:30H		PROMO	X	X
5		PM				4:30		X	X
6	ALLYSE	AM	1030			X		1030
7		PM		4:30		X			330
8	ANGIE	AM					4:30	1030
9		PM	4:30
10	ANNA	AM	X		1030	1030	1030		X
11		PM	X						X
12	ASHLEY	AM
13		PM
14	BRITTNEY	AM					1030	X
15		PM	430	4:30		4:30		X	330
Sheet1

I'd like to have worksheets Monday - Sunday that have already read the Weekly Schedule and have two lists - one for those that are scheduled for the AM shift and one for the PM.

Is there a function that will handle this for me or is there some coding required?

Thanks for everything... there is some really great stuff in here.

Charlie

 

[shemayisroel]

If I understand it correctly you are wanting 7 tabs - one for each day that simply ready off your weekly schedule?

Example in Mondays tab you will only display People and times rostered for Monday etc?

 

[chaz4070]

Yes. One tab for each day that correctly reads the "Weekly Schedule" and compiles the list with ONLY those that are scheduled for that shift on that day.

My goal after creating a schedule is to just click on a particular's day tab, hit print, and have my roster already done. Currently, we are doing them by hand and with some of the people I work with, it isn't reliable. Also, it would save me a lot of time every week... Right now, we have over 45 people on the schedule, with an average 9-13 working each shift.

Thanks!!!

 

[frustratedrestaurantmanag]

did you ever figure out how to do the daily schedule from the weekly schedule? I have the same problem.

thanks!!!