Excel Query

[Schizophonic]

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?

 

[Schizophonic]

Sorry, reading back it was horrible to write and explain.

You can download the shift rota sheet here:

http://dl.dropbox.com/u/47397259/Shift Rota.xls

 

[Schizophonic]

Try something like this:

http://dl.dropbox.com/u/47623467/Shift Rota.xls

I'm running Office 2007 and when I try to click on the drop down, its not letting me change any dates. I've noticed its in compatibility mode, does the drop down still function?