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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|