Recurring event and filtering in Excel calendar

[sunzal]

Hi all -

I have an event calendar which I have created using an existing template I sourced online which I then customised slightly. It generally serves my purposes but there are two additional functions I would like to now add.

The template works by inputting data into the Event List worksheet, which then auto-populates the calendar views which are in the subsequent sheets, colour coding based on conditional formatting.

The two additional functions I would like to add are:

1. Ability to add a recurring event only once in the event list but have the item show on a weekly/fortnightly basis in the calendar views. This is to prevent the event list becoming long and unwiedly with recurring event names eg. 52 entries for a weekly newsletter.

2. Add an extra column to the event list, where by a category can be assigned to the event and upon instruction, the calendar views will show only events assigned a particular category. Preferably that would be determined through one action, say on the Event List worksheet (and not something on each of the calendar view).

Sample of my document here - https://dl.dropboxusercontent.com/u/19189780/Calendar of Events 2014.xlsx

I would greatly appreciate any advice with this.
Many thanks.

 

[James006]

Hi,

The solution depends very much on your Excel knowledge ... and if you are considering using VBA or not ...

For sure, you have already noticed all the hidden columns in the Event List worksheet ...

For the two new functions, you will need specific identifiers i.e. two new columns ...

HTH

 

[sunzal]

Thanks James 006

I have an intermediate knowledge of excel and am familiar with vba but have not used in the past. More than happy to start now though.

I understand that my next steps would be to add new columns in order to assign a category (by which to filter) and assign a frequency eg weekly, which would reference a number of days ie 7, but I am unsure then how to draw this into the calendar view.