I have several workbooks with an employee calendar on each one
In A1 employee name = John Doe - Jane Doe - Tom Thumb etc.
In each calendar A13 through G27 is January ( E 16,17,&18 are Jan. 8 )
If an employee books vacation I enter V in the appropriate spot
is it possible to have a seperate work book that will display the persons
name in the same day as the V was entered so if John Doe and Jane Doe both
booked the same day off it would dissplay both name in the same day
so if they both book Jan. 8 as vacation, sheet 3 Jan 8 will show John Doe
and Jane Doe
--
grizz

Have you considered a Gantt chart?
x97gantt at the following website will show you how to set up a spreadsheet
to show how to lay it out, formula to use and how to set up conditional
formats.

http://www.bygsoftware.com/examples/...ect%20Planning


On Fri, 24 Jul 2009 16:11:01 -0700, grizzly6969 wrote:

I have several workbooks with an employee calendar on each one
In A1 employee name = John Doe - Jane Doe - Tom Thumb etc.
In each calendar A13 through G27 is January ( E 16,17,&18 are Jan. 8 )
If an employee books vacation I enter V in the appropriate spot
is it possible to have a seperate work book that will display the persons
name in the same day as the V was entered so if John Doe and Jane Doe both
booked the same day off it would dissplay both name in the same day
so if they both book Jan. 8 as vacation, sheet 3 Jan 8 will show John Doe
and Jane Doe