Daily Schedule with Start, End, Weekday criteria

[Linebacker2]

Hello.

Thank you in advance. I have a scheduling problem where I have multiple people scheduled over a period of time to work on specific days of the week at given times:

Column A=Name (ex. Judy)
Column B=Function (ex. Bartender)
Column C=Start Date (ex. May 11, 2011)
Column D=End Date (ex. Sept 10, 2011)
Column E=Days of the week (ex. 1.3.5.7)
Column F=Start Time (07:00pm)
Column G=End Time (11:00pm)

I am trying to develop vba that will allow me to build in one new worksheet a daily schedule for 20 employees by day sorted by calendar day, function and start time.

Kind regards.