Excel Query

Soldato
Joined
27 Dec 2006
Posts
2,912
Location
Northampton
Help, dont know how to word this in google but I've been task to devise a simple rota sheet.

I've created a drop down indicating the week commencing for 2012 and below that I've created a little chart which shift people are on.

Problem is, when I choose a date for example Week commencing 02/01/2012 and indicate Employee 1 and 2 are one the 8am shift.

I click on the drop down for the following week 09/01/2012, employee 1 and 2 still show on the 8am shift and should be on the 9am shift.

How do i get the 'indication' to show correctly which box people are on?
Get me?
 
Back
Top Bottom