I am attempting to create a workbook that consists of 4 worksheets.
What I am trying to do is create a training/vacation/personal day
document, One worksheet for each and the 4th worksheet being layed out
into a calendar (jan, feb, mar, etc...). What I want to do is enter
dates in the first 3 worksheets (train, vac, pers) and then have them
show up in the 4th worksheet in the corresponding cell for each staff
member coloring in the correct dates on the calendar. Training would be
1 color, Vacation would be another & Personal Day yet another. In the
1st 3 worksheets, each consecutive date range has just start / end date
entered and then a 3rd column for # of consecutive days for each staff
member.
For example staff member 1 wants training on Jan 1-5 and vacation on
Feb 1-5 and personal days on Feb 8 and 10. Cells would look like this
WS-1
WHO | Start | END |
-------------------------------------------------
STAFF-1 | 1/1/06 | 1/5/06 |

WS-2
WHO | Start | END |
-------------------------------------------------
STAFF-1 | 2/1/06 | 2/5/06 |

WS-3
WHO | Start | END |
-------------------------------------------------
STAFF-1 | 2/8/06 | 2/8/06 |
| 2/10/06| 2/10/06 |

I would like based of the above to have on the 4th worksheet to have
the cell coordinates for STAFF-1 to be colored Yellow for Jan 1 thru
Jan 5, Red for Feb 1 - Feb 5 and GRN for Feb 8 & Feb 10 automatically.
And if I change the dates, they are updated on the 4th sheet
automatically.

Anybody out there who can point me in the right direction.
I work w/ Excel frequenly but by no means a guru

Thanks
GM

how does the calendar (WS4)show the different staff members??
paul
remove nospam for email addy!



"gm" wrote:

I am attempting to create a workbook that consists of 4 worksheets.
What I am trying to do is create a training/vacation/personal day
document, One worksheet for each and the 4th worksheet being layed out
into a calendar (jan, feb, mar, etc...). What I want to do is enter
dates in the first 3 worksheets (train, vac, pers) and then have them
show up in the 4th worksheet in the corresponding cell for each staff
member coloring in the correct dates on the calendar. Training would be
1 color, Vacation would be another & Personal Day yet another. In the
1st 3 worksheets, each consecutive date range has just start / end date
entered and then a 3rd column for # of consecutive days for each staff
member.
For example staff member 1 wants training on Jan 1-5 and vacation on
Feb 1-5 and personal days on Feb 8 and 10. Cells would look like this
WS-1
WHO | Start | END |
-------------------------------------------------
STAFF-1 | 1/1/06 | 1/5/06 |

WS-2
WHO | Start | END |
-------------------------------------------------
STAFF-1 | 2/1/06 | 2/5/06 |

WS-3
WHO | Start | END |
-------------------------------------------------
STAFF-1 | 2/8/06 | 2/8/06 |
| 2/10/06| 2/10/06 |

I would like based of the above to have on the 4th worksheet to have
the cell coordinates for STAFF-1 to be colored Yellow for Jan 1 thru
Jan 5, Red for Feb 1 - Feb 5 and GRN for Feb 8 & Feb 10 automatically.
And if I change the dates, they are updated on the 4th sheet
automatically.

Anybody out there who can point me in the right direction.
I work w/ Excel frequenly but by no means a guru

Thanks
GM

paul,
Thanks for responding. I have WS4 set up in calendar format as
follows

January
February
1 2 3 4 .....................31 1 2
3................................................. ..28
STAFF1
STAFF2
STAFF3

March
April
1 2 3 4 ..............................31 1 2 3
4........................................30
STAFF1
STAFF2
STAFF3

follows this format through DEC
I'm open to changing format of WS4 - this format is not set in stone