A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Viewing other worksheets in a main worksheet



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2009, 09:39 AM posted to microsoft.public.excel.misc
Brockwood
external usenet poster
 
Posts: 3
Default Viewing other worksheets in a main worksheet

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
  #2  
Old May 14th, 2009, 11:07 AM posted to microsoft.public.excel.misc
Pete_UK
external usenet poster
 
Posts: 8,780
Default Viewing other worksheets in a main worksheet

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


  #3  
Old May 14th, 2009, 11:26 AM posted to microsoft.public.excel.misc
Brockwood
external usenet poster
 
Posts: 3
Default Viewing other worksheets in a main worksheet

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 a

Across Specialims
CYPD
OPS
C4U
LD
PD

There will probably be others added later

"Pete_UK" wrote:

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



  #4  
Old May 14th, 2009, 11:53 AM posted to microsoft.public.excel.misc
Pete_UK
external usenet poster
 
Posts: 8,780
Default Viewing other worksheets in a main worksheet

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

On May 14, 11:26*am, Brockwood
wrote:
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 a

Across Specialims
CYPD
OPS
C4U
LD
PD

There will probably be others added later



"Pete_UK" wrote:
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- Hide quoted text -


- Show quoted text -


  #5  
Old May 14th, 2009, 12:45 PM posted to microsoft.public.excel.misc
Brockwood
external usenet poster
 
Posts: 3
Default Viewing other worksheets in a main worksheet

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

Jim

"Pete_UK" wrote:

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

On May 14, 11:26 am, Brockwood
wrote:
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 a

Across Specialims
CYPD
OPS
C4U
LD
PD

There will probably be others added later



"Pete_UK" wrote:
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- Hide quoted text -


- Show quoted text -



  #6  
Old May 16th, 2009, 05:33 AM posted to microsoft.public.excel.misc
TechGuy[_2_]
external usenet poster
 
Posts: 49
Default Viewing other worksheets in a main worksheet

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.