Hi there -
I have been customising an existing excel calendar template which for the most part works as I would like it, but there are some additional elements that I would like to add. I am pretty familiar with Excel, but in saying that I have not used macros/VBA in the past, however am not afraid to try now!
The template works on the basis of entering events into the Events List which then auto populates the monthly views.
What I would like is to add a column in the events list to specify whether the event is a recurring event, on a weekly, fortnightly or monthly basis (monthly as in 1st of every month, as well as 1st/2nd/3rd etc Tuesday of every month).
If possible, I would also like to add a category column to the events list, with 3 options, in order to be able to display only these types of events in the monthly views (less of a priority than the above point as I can always filter the list and get this information from the list view).
I have been searching and have seen some formulas for recurring events but I can't work out how I would add this to the existing formula that already sit in the cells of the month view sheets.
Any guidance would be greatly appreciated! I've attached my document below so you can see in context.
Bookmarks