Making a single table visible form a list selection - CLOSED

[higgzy]

Hey guys,

Sorted!
I'm new to this forum and haven't been using excel for too long so I apologise in advance for my poor explanations and lack of jargon.
I'm having trouble finding information on how to make excel provide me with a table when I choose from a list for example:

I make a list with year 9, 10, 11, 12
- year 9 has a table with column 1 being year 9 subjects 1, 2, 3, 4 etc, column 2 being further info on subject, column 3 being time of subject and so on
- year 10 has a table with column 1 being year 10 subjects1, 2, 3, 4 etc with same layout as above but different content.
This goes on for all years.

then have a list showing "All years" which is pretty much how my spreadsheet is currently laid out.

The attachment will hopefully give you a greater understanding of where I'm coming from.

Thanks for reading and helping me out!

Sam

[aydeegee]

Hi higgzy

Welcome to the forum.

I have seen your spreadsheet and can understand where you are coming from. I am less clear about where you want to go!

I could not see any difference between your 2 sheets. I note that your months seem to be divided into four. Is this weeks, if so does it matter that most months have over 4 weeks?

Perhaps if you were to mock up the sort of thing you want to see we can try to help you achieve that.

Regards
Alastair

[FDibbins]

Hi and welcome to the forum

I have taken a look at your files too, and cannot see any obvious differences? (I actually transfered the 2nd file into the 1st file so it's easier to work with)

Perhaps some samples showing what your expected outcome is, and how you arrived at that?

[higgzy]

Sorry I didn't mean to post 2 up. I got it looking better so I'll show you where I'm at so far (See attached)

Sorry to confuse you.

In essence I would like all the subjects in one drop down list and depending on the subject you choose depends on what you will see.

If I choose subject 1 I see activity 1-15 from subject 1 if I chose subject 2 I'll see activity 1-15 and so on.

Thanks for you time

Sam

[aydeegee]

Hi Sam

I now see what you want - but do you not already have that?
"If I choose subject 1" Ok so click on the "+" right next to Subject 1 you can see activity 1 - 15.

How can we assist?

As a side issue I note that your end dates are all 1 Jan 2013. They could be set up as start date + days (from column D)

Regards
Alastair

[higgzy]

I've almost got it I would like it though so that only one subject is visible at a time depending on the selection. i.e have a list SUBJECT 1-SUBJECT 6. If you select Subject 1 from the list it shows you all the activities under subject 1. If you select Subject 2 it shows you all the activities under subject 2.

Thanks for that I have fixed it up. Also on a side issue is it possible, as this is a shell, to direct changes made to the shell onto documents that use this shell as their base. For example if I change the layout slightly that layout will be sent over to the documents. Using the side issue as an example if I have 3 documents based off the shell document and I change the end date column so it uses an equation, it changes the 3 documents to an equation also?

Thanks for your help thus far!

Sam

[aydeegee]

Hi Sam

Yes, it is possible to effect changes on other sheets, but it takes quite a bit of setting up and is not particularly suited to one off adjustments.

I have inserted a column at A (it could be anywhere eg after your last column) and added a filter. You can now see just one (or more) Subject at a time.

Regards
Alastair

[higgzy]

Great thanks for your help!

Sam

[aydeegee]

Hi Sam

Glad to have been of assistance. If this thread is now closed, perhaps you will mark it as such? (On your first post, go into the header and amend.)

Regards
Alastair