Hi, not sure how difficult this is as im no expert on Excel.
I have 2 spreadsheets one with details of holidays, ie start date, end date, number of hours taken etc, and another spreadsheet set up as a rota with all dates across the top and staff down the left side.
What i want is to be able to enter a date in the holiday spreadsheet and have the corresponding date on the rota spreadsheet change to a 'H' and turn blue.
ie. i enter 09/12/2003 as a holiday and the cell in the rota spreadsheet changes as below, but colour aswell.
BEFORE:
* |09/12/2003|10/12/2003|
PB| D | D |
AFTER:
* |09/12/2003|10/12/2003|
PB| H | D |
Hope that makes sense. Any ideas where to start with this?
Thanks very much
Pete
I have 2 spreadsheets one with details of holidays, ie start date, end date, number of hours taken etc, and another spreadsheet set up as a rota with all dates across the top and staff down the left side.
What i want is to be able to enter a date in the holiday spreadsheet and have the corresponding date on the rota spreadsheet change to a 'H' and turn blue.
ie. i enter 09/12/2003 as a holiday and the cell in the rota spreadsheet changes as below, but colour aswell.
BEFORE:
* |09/12/2003|10/12/2003|
PB| D | D |
AFTER:
* |09/12/2003|10/12/2003|
PB| H | D |
Hope that makes sense. Any ideas where to start with this?
Thanks very much
Pete