G
gm
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 | # of Days
-------------------------------------------------
STAFF-1 | 1/1/06 | 1/5/06 | 5
WS-2
WHO | Start | END | # of Days
-------------------------------------------------
STAFF-1 | 2/1/06 | 2/5/06 | 5
WS-3
WHO | Start | END | # of Days
-------------------------------------------------
STAFF-1 | 2/8/06 | 2/8/06 | 1
| 2/10/06| 2/10/06 | 1
I would like based off the above is for 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
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 | # of Days
-------------------------------------------------
STAFF-1 | 1/1/06 | 1/5/06 | 5
WS-2
WHO | Start | END | # of Days
-------------------------------------------------
STAFF-1 | 2/1/06 | 2/5/06 | 5
WS-3
WHO | Start | END | # of Days
-------------------------------------------------
STAFF-1 | 2/8/06 | 2/8/06 | 1
| 2/10/06| 2/10/06 | 1
I would like based off the above is for 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