Your approach seems a bit unwieldy - you will end up with 60 sheets,
one for each training type per month.

I would suggest that you enter all the details of the training events
into one main sheet, and then on another sheet you can select the
month/year from a pull-down and also select the training area from
another pull-down.

I put a planner together some time ago along these lines, where
activity plus date is entered in one sheet in any order, and then on a
calendar sheet you can select the month and see all those activities
arranged on the appropriate day, with up to 7 events per day. This
could be extended to enter a training area on the activities sheet,
and then adjust the calendar with a pull-down for training.

What training areas will you have?

Pete

On May 14, 9:39*am, Brockwood
wrote:
Hi guys,

I'm currently creating a calendar of events for our training centre. Each
month on its own worksheet but with multiple worksheets with the same month
on as there are a few different types of training

What I really need is one main worksheet with 2 drop down lists, one that
will specify the area of training, the next the month. This would then
display on this main worksheet the month calendar that the person is
interested in.

Really it’s just a case of being able to view other worksheets on one main
worksheet using a filter with 2 conditions. The calendars will already be set
up on other work sheets so I'll have 5 May calendars each with a different
area of training, 5 June, 5 July and so on. I just need the ability to filter
those so I can show just one of them on the main worksheet ( I'll only need
to see one month at a time)

Hope someone can help I'm stumped