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