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.
