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

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