Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheetfunctinos,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Spreadsheet to Create/Update Monthly Calendar
Good Morning Everyone,
Has anyone come across an Excel generated monthly calendar updated using data stored in an Excel spreadsheet? For example, let's say I have a column with the date 16-Mar-06. Under the date column I have the task "Attend Propulsion Mtg." I would like to see a montly calendar for March created and the task "Attend Propulsion Mtg." placed in the box for the day (16 March). I may have additional tasks for the same day. The calendar will need to display them all. If it would be easier, I already have a monthly calendar created. I just do not know how to programmatically place the task in the corresponding calendar box for a particular day. The data containing the date and task can be placed as a column/column; column/row; row/row. It does not matter. I can change the spreadsheet to meet your recommendations. Your assistance is greatly appreciated. Thank you! Edwin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I embed my Outlook Calendar into an Excel Spreadsheet? | Excel Discussion (Misc queries) | |||
how do I export excel to a monthly calendar format? | Excel Discussion (Misc queries) | |||
how do I export excel to a monthly calendar format? | Excel Discussion (Misc queries) | |||
How can I import dates from an Excel spreadsheet into a calendar . | Excel Worksheet Functions | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |