I am trying to figure out a way to create a work schedule for employees via
EXCEL.
I want the scheduler to use one workbook, defining certain info like
beginning date of schedule and actually creating the schedule (indicating who
is working when), then create a new workbook with the schedule in it.

1) Can this be done?

2) If it can be done, can you provide sample coding that transfers the
schedule from the original workbook to the new workbook that is sent to
employees?

Thanks,
Les