Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
*****Upgrading Calendar for Office Manager*****
I have created a calendar, last year, for my office manager but I come to the conclusion I need something more than just a calendar for the users to plot their H - Holiday, P - Personal, S - Sick, F - Floater, and V - Vacation. I have created a Settings, Calendar, and Report Tab. The months Feb-Dec are to be ignored since I had that setup last year. The area of concern is: What would be the best means of generating a report based on the corresponding letters and using the tab information below? The *Settings *tab (which will be hidden) changes the date based on the month, day, year. The *Calendar *tab is the interface the users will be working from when plotting H - Holiday, P - Personal, S - Sick, F - Floater, and V - Vacation. The *Report *tab is for the office manager and users to see a running total of the amount of days taken off of the specified month. Thank you in advance for any advice. Please see excel attachment: http://www.jpierce.com/~awebtech/2006_Time_Off.xls -- donnyusf ------------------------------------------------------------------------ donnyusf's Profile: http://www.excelforum.com/member.php...o&userid=31029 View this thread: http://www.excelforum.com/showthread...hreadid=506984 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Calendar issue | Excel Discussion (Misc queries) | |||
looking for ideas for calendar in sheet with separate months | Excel Worksheet Functions | |||
Erasing Outlook Calendar from within Excel | Excel Discussion (Misc queries) | |||
Calendar and info for that date | Excel Discussion (Misc queries) |