Question

Locked

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

By rjurasek ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums