Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA to Populate a Calendar Template
I am trying to create a tool for my boss that will automatically update a
calendar template; so that he can see who will be where and when. I have a worksheet with the following information: Name, Departure Day, Return Date, Location, and Reason for trip. I can create a form that will allow the employees to update this information easily. What I would like to do is have my boss be able to push a command button or upon opening this file the calendar for the current month will automatically update and show all the information in the table. When some on is gone for a week; each day that they are gone needs to show their name; where they are at; and reason for the trip. Can anyone help? I greatly appreciate any and all suggestions. Thanks, Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you auto populate tasks into a calendar | Excel Worksheet Functions | |||
need help w-populate calendar every-other-day | Excel Programming | |||
How do I populate 2006 calendar into the attendance template. | Excel Worksheet Functions | |||
Need a calendar plug in, to help populate a cell with date | Excel Programming | |||
Populate a cell with a date using calendar pick | Excel Discussion (Misc queries) |