Converting a list of dates in Excel into actual cells in a Calendar - TechRepublic
Question
September 17, 2008 at 07:08 AM
rjurasek

Converting a list of dates in Excel into actual cells in a Calendar

by rjurasek . Updated 17 years, 10 months ago

I have a 12-Tab Excel Calendar spreadsheet created with each tab designated as a separate month in a year. I’d like to add another tab with four columns: Event, Date, Start and End time. This new Tab would contain a list of about 85 events. Is there a macro / command that I could use to convert each item on the list into the actual date space in each respective calendar. I would envision the calendar entry to take up two lines: First line would be the start and end time, the Second line would contain the event. Potentially, it might be wise to add a fifth colum to the list – Location and have that added to the calendar.

This discussion is locked

All Comments