Hi,

I wish to create a roster tool for managers (who are very basic Excel users)
to plan the shifts of workers. There are a selection of standard shifts but
non-standard shifts are often needed. The required shifts change each pay
period.

Sheet 2 is called Shifts. Row 1 columns A to L is as follows
Shift StartTime FinishTime MealBreak HrsPaid Mon Tue Wed Thu Fri Sat Sun
Row 2 and following will have the ShiftName in column A and then the detail
of the standard shifts across the row.

Sheet 1 is called Roster. Row 1 columns A to L is as follows
Shift StartTime FinishTime MealBreak HrsPaid Mon Tue Wed Thu Fri Sat Sun
The intention is the ShiftName will be entered in column A and the detail
will be populated in columns B to L. Vlookup seems to be the answer and that
is fine.

But, how can users enter a non-standard shift? ie they enter the detail
themselves?
Plus, how can users then change the non-standard shift back to a standard
shift?

Please help! (I do not use VB so if that is the answer please take it slowly)

Thanks, Ando