calendar

jeffmfrank · Mar 4th, 2002, 03:46 PM

I'm trying to create a tool that includes a printable one-month desk calendar. The days need to populate from entries in a list with the fields, "Date" & "Event". Multiple events (up to 12) can occur on the same day, and events will not always be entered in chronological order. Any suggestions on an approach? (A vlookup for date values equal to the day on the calendar seems inadequate since it would need to return multiple entries and the entries are not in order).

Chris Davison · Mar 5th, 2002, 12:45 PM

Hi Jeff,

could a pivot table achieve what your after ? How about a Gantt Chart ? (there's an example in the tip-of-the-day files here on Mr Excel.... something I later used to schedule out my monthly duties and dates at work)

[I assumed it was free]

Mar 5th, 2002, 12:45 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Hi Jeff, could a pivot table achieve what your after ? How about a Gantt Chart ? (there's an example in the tip-of-the-day files here on Mr Excel.... something I later used to schedule out my monthly duties and dates at work) [I assumed it was free] __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 03:46 PM	#1
jeffmfrank Board Regular Join Date: Feb 2002 Location: Arizona Posts: 72	I'm trying to create a tool that includes a printable one-month desk calendar. The days need to populate from entries in a list with the fields, "Date" & "Event". Multiple events (up to 12) can occur on the same day, and events will not always be entered in chronological order. Any suggestions on an approach? (A vlookup for date values equal to the day on the calendar seems inadequate since it would need to return multiple entries and the entries are not in order).