Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Excel Data as a Calendar
Wondering if there is a macro around that can interpret a list of data
(within a dae range) and display them in a calendar view. This will help to visually analyse for trends in events that occur on certain days of the week. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Excel Data as a Calendar
Probably different than what you want, but you can try it:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=21 I'm not sure I've ever seen what you described, but some people in this DG are VERY creative so someone may come up with something for you. Regards, Ryan--- -- RyGuy "haileybury" wrote: Wondering if there is a macro around that can interpret a list of data (within a dae range) and display them in a calendar view. This will help to visually analyse for trends in events that occur on certain days of the week. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Excel Data as a Calendar
There's a sample file here that will display a list of tasks in a weekly
calendar view: http://www.contextures.com/excelfiles.html Under Functions, look for 'FN0014 - Task List and Calendar' haileybury wrote: Wondering if there is a macro around that can interpret a list of data (within a dae range) and display them in a calendar view. This will help to visually analyse for trends in events that occur on certain days of the week. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Excel Data as a Calendar
Thanks a lot. I will look into tweaking this to meet my specific requirements.
Regards "Debra Dalgleish" wrote: There's a sample file here that will display a list of tasks in a weekly calendar view: http://www.contextures.com/excelfiles.html Under Functions, look for 'FN0014 - Task List and Calendar' haileybury wrote: Wondering if there is a macro around that can interpret a list of data (within a dae range) and display them in a calendar view. This will help to visually analyse for trends in events that occur on certain days of the week. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Excel Data as a Calendar
After looking into this further, I think my requirements are such that it
cannot be handled through cell formulas. The range of data that I would process would be a minimum for 1 year (365 lines ) and could be as much as 3 years (3 * 365 lines). I figure I would need a macro that will loop through raw data and output it as a condensed yearly calendar... "haileybury" wrote: Thanks a lot. I will look into tweaking this to meet my specific requirements. Regards "Debra Dalgleish" wrote: There's a sample file here that will display a list of tasks in a weekly calendar view: http://www.contextures.com/excelfiles.html Under Functions, look for 'FN0014 - Task List and Calendar' haileybury wrote: Wondering if there is a macro around that can interpret a list of data (within a dae range) and display them in a calendar view. This will help to visually analyse for trends in events that occur on certain days of the week. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to display the excel atcive control calendar to enter dates | Excel Discussion (Misc queries) | |||
monthview calendar question/ want the calendar to display weekdays only.. | Excel Programming | |||
display Calendar for Excel field entry? | Excel Worksheet Functions | |||
Display dates from an Excel spreadsheet in a calendar? | Excel Worksheet Functions | |||
display a set of data as a calendar | Excel Programming |