Viewing other worksheets in a main worksheet

[Brockwood]

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

 

[Pete_UK]

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

 

[Pete_UK]

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

 

[Brockwood]

I see what you mean, so rather than entering in a calendar to start of with,
just enter it all in list and use the other sheet to filter. I'm not sure how
I would get that to display in an appropriate calendar rather than a filter
list though

The areas I have at the moment are:

Across Specialims
CYPD
OPS
C4U
LD
PD

There will probably be others added later

 

[Brockwood]

I see what you mean, so rather than entering in a calendar to start of with,
just enter it all in list and use the other sheet to filter. I'm not sure how
I would get that to display in an appropriate calendar rather than a filter
list though

The areas I have at the moment are:

Across Specialims
CYPD
OPS
C4U
LD
PD

There will probably be others added later

 

[Pete_UK]

Send me an email to:

pashurst <at> auditel.net

(change the obvious), and I'll send you a copy of my file amended to
take account of these training areas (probably this evening).

Hope this helps.

Pete

 

[Pete_UK]

Send me an email to:

pashurst <at> auditel.net

(change the obvious), and I'll send you a copy of my file amended to
take account of these training areas (probably this evening).

Hope this helps.

Pete

 

[Brockwood]

Thanks Pete I really apreciate it. When ever you get chance would be fine

Jim

 

[Brockwood]

Thanks Pete I really apreciate it. When ever you get chance would be fine

Jim

 

[TechGuy]

With regard to the Excel calendars, the free Excel Calendars found
here may save you some time
http://www.wincalendar.com/excel-calendar-template.htm

Mike

 

[TechGuy]

With regard to the Excel calendars, the free Excel Calendars found
here may save you some time
http://www.wincalendar.com/excel-calendar-template.htm

Mike