Excel Boffins required!

[hp01jpc]

Can anyone help me with this. I think it's quite a simple task I am trying to do...

I am on a flexible shift pattern at work, and I want to create a calendar in excel that will allow me to automatically populate the weeks in the calendar with my start and finish times. It works so that one week I may be on "shift pattern 1" and will be doing 9-5's, then the next week I will be on pattern 2 and doing 8-4's. All I want to do is to be able to create a list for the weeks in the month, with the selection of shift patterns, which will then fill in the days of that week with my hours.

Pretty simple eh? I figure the way around it is to make some kind of reference table with the shift patterns, which Excel then draws the data from to put into the week in question. But exactly how I make it do this I am unsure.

If someone could so much as give me a hint how to get started, I can normally figure this kind of thing out.

Cheers

 

[TheKnat]

I think what your looking for is the vlookup function. You would need to create table which had the shift patterns on it. You would then create a separate table to display the months and then depending on what you select (SP1, SP2) you would do a vlookup on the first table to display the data.

I probably explained that really badly but I think that should help a bit

EDIT:
Just checked and this does work. I managed to knock together a quick and dirt spreadsheet which does what you wanted it to, so its not too hard to get it working.

 

[hp01jpc]

Thank you, that's brilliant. I'll give it a go