View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jennifer Jennifer is offline
external usenet poster
 
Posts: 385
Default Convert listing of events with dates to calendar - Pls help

yes these are 3 separate events that need to appear on the calendar. I can
work on abbreviations but still need help on how to convert the list and
create separate worksheets in a calendar format for the 12 months.

Thanks!

"Tom Ogilvy" wrote:

I am sure you could using a macro

Seminar, Posting and End are 3 different events?

One challenge would be fitting the information within the "box" which would
depend on the length of the text describing the event and the number of
events which might occur for 1 box (date).

--
Regards,
Tom Ogilvy

"jennifer" wrote in message
...
Is there a way to convert a table that lists events with dates to a

calendar
format? For example, I have

Event Date
Seminar 4/15/2005
Posting 5/4/2005
End 7/20/2005

I would then have individual sheets for the months with the items above in
the appropriate boxes in the month calendar. Any help would be

appreciated!