looking for help again
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 |
looking for help again
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 |
All times are GMT +1. The time now is 02:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com