Question Locked
Converting a list of dates in Excel into actual cells in a Calendar
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.