#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
STO STO is offline
external usenet poster
 
Posts: 3
Default Calendar linking

has anyone had sucess creating a calendar from a data table in Excel?
I have a table that list items in column A and formatted dates in column B
It would be great if the items could be linked and posted on a calendar
template, either in Excel or word.
there wuld also be the need to have multiple items posted on individual days.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default Calendar linking

There's a sample file here that links tasks to a calendar based on date
and time. Maybe it will help you get started:

http://www.contextures.com/excelfiles.html

Under Functions, look for 'FN0014 - Task List and Calendar'

STO wrote:
has anyone had sucess creating a calendar from a data table in Excel?
I have a table that list items in column A and formatted dates in column B
It would be great if the items could be linked and posted on a calendar
template, either in Excel or word.
there wuld also be the need to have multiple items posted on individual days.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking workbook info to excel calendar S Willingham Excel Discussion (Misc queries) 0 March 29th 07 03:58 AM
Spreadsheet Linking to Calendar KK Excel Discussion (Misc queries) 0 September 15th 06 09:13 PM
Linking info to a calendar shinkson Excel Discussion (Misc queries) 0 March 29th 06 10:33 PM
Excel should allow calendar based spreadsheet linking. kacivic Excel Worksheet Functions 1 June 4th 05 01:44 PM
Linking dates with a calendar... mcboots Excel Worksheet Functions 2 November 17th 04 04:11 AM


All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"