Hi,
We are having many errors in shift rostering in our organization. I therefore have planned to make a shift roster which can avoid errors.

The concept what i have here is that the names will be listed in sheet "A" along with the shift timings.
Workbook two will have formulas For eg: If i have created
1) 7.30am- 4.30pm
2) 4.30 - 1.30

When i enter an option in sheet two the shift should change for everyone and should rotate sequentially i.e if a person was working in 1 st shift last week. This week when preparing the roster when option 2 is pressed he should automatically change to 2nd shift and the person in 2nd shift to 3rd shift and so on.

What i mean is here all the people get to work in all shifts and the confusion is reduced.

Kindly help me in making this a success or give me idea as to how i can prepare this.
Any assistance would be greatly appreciated.

Warm Regards,
Chaitanya