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?

 

[Linkex]

Sorry, read that twice and I can figure out what your tring to do. If you can post a screenshot, that might help.

 

[Participant]

Surely this either means that your chart is showing them as being on the 8am shift for w/c 09.01.12? Either that or your formulae are wrong. Impossible to say without a sample / more info.

 

[PMKeates]

No we don't 'get' you because that's the worst Excel problem description I think I've ever seen.

 

[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%20Rota.xls

 

[Participant]

I would personally keep it very simple in your case and just create a massive table detailing each shift on each day (you'll have to do this anyway), then use autofilter to set the date you want to query:

 

[Linkex]

Try something like this:

http://dl.dropbox.com/u/47623467/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?

 

[Linkex]

It should do, its just a list with data validation - the same as you already had set up before. Just re-do the validation if its not working.