| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
import excel 2003 dates & notes to Julian calendar format?
I am trying to import data from an excel 2003 spreadsheet into a Julian
calendar format. I have 2 side by side columns - one column contains a date and the other column contains a task to be completed on the date. I would like to know if there is a way to have the info in the excel 2003 worksheet feed into a standard calendar (boxed format) and populate the calendar with the related task. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
import excel 2003 dates & notes to Julian calendar format?
Send me an email to:
pashurst <at auditel.net (change the obvious) and I can send you a workbook that does exactly this. An activities sheet is used to list the date and task (in any order), and on the calendar sheet you can select the month and year from two pull-downs and the activities are shown on the appropriate day (up to 7 tasks per day). Hope this helps. Pete On May 22, 4:50*pm, Cynthia N <Cynthia wrote: I am trying to import data from an excel 2003 spreadsheet into a Julian calendar format. I have 2 side by side columns - one column contains a date and the other column contains a task to be completed on the date. I would like to know if there is a way to have the info in the excel 2003 worksheet *feed into a standard calendar (boxed format) and populate the calendar with the related task. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
import excel 2003 dates & notes to Julian calendar format?
Thanks I will send you a seprate e-mail with attachment!
"Pete_UK" wrote: Send me an email to: pashurst <at auditel.net (change the obvious) and I can send you a workbook that does exactly this. An activities sheet is used to list the date and task (in any order), and on the calendar sheet you can select the month and year from two pull-downs and the activities are shown on the appropriate day (up to 7 tasks per day). Hope this helps. Pete On May 22, 4:50 pm, Cynthia N <Cynthia wrote: I am trying to import data from an excel 2003 spreadsheet into a Julian calendar format. I have 2 side by side columns - one column contains a date and the other column contains a task to be completed on the date. I would like to know if there is a way to have the info in the excel 2003 worksheet feed into a standard calendar (boxed format) and populate the calendar with the related task. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Export Calendar to Excel along with daily notes? | Excel Discussion (Misc queries) | |||
| create a filled in calendar from list of dates and notes | Excel Discussion (Misc queries) | |||
| Dates from Julian calendar | Excel Discussion (Misc queries) | |||
| looking for a calendar template that I can import multiple dates | Excel Discussion (Misc queries) | |||
| How can I import dates from an Excel spreadsheet into a calendar . | Excel Worksheet Functions | |||
Linear Mode
