Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leave Calendar
Hi,
Hope someone has the answer to this!! I have a workbook consisting of 12 sheets ( April-March ). Input 01/04/???? into April A1. Column A contains all my drivers names, rows 2 + 3 have day and date respectively. The drivers(126 of them) all work a shifted week, so their days off are not all the same (one driver has Mon/Tue off, another has Wed/Thu off etc.) the two corresponding cells in the row next to their name are shaded in for their days off. I have managed to get each sheet to corectly display day/date in B2/3 - AF2/3 from the input into sheet April A1. What I need Excell to do if possible is to automatically shade in the drivers days off on each sheet when I create a new calendar for next year |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Leave Calendar
"kevhatch" wrote: Hi, Hope someone has the answer to this!! I have a workbook consisting of 12 sheets ( April-March ). Input 01/04/???? into April A1. Column A contains all my drivers names, rows 2 + 3 have day and date respectively. The drivers(126 of them) all work a shifted week, so their days off are not all the same (one driver has Mon/Tue off, another has Wed/Thu off etc.) the two corresponding cells in the row next to their name are shaded in for their days off. I have managed to get each sheet to corectly display day/date in B2/3 - AF2/3 from the input into sheet April A1. What I need Excell to do if possible is to automatically shade in the drivers days off on each sheet when I create a new calendar for next year. Many Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Adding absences in rolling twelvemonths in a calendar | Excel Discussion (Misc queries) | |||
Excel Spreadsheet to Create/Update Monthly Calendar | Excel Discussion (Misc queries) | |||
Calendar issue | Excel Discussion (Misc queries) | |||
Erasing Outlook Calendar from within Excel | Excel Discussion (Misc queries) |