Show data dependant on selection from drop down box

[Guest]

Hi all, hope somone can help!
I wish to create a spreadsheet whereby the 'summary' sheet contains a
dropdown box list, say months of the year, and on selecting a month in the
list the summary sheet would then display data from another so-named
worksheet in the same book.
The monthly data sheets may gain extra headings which would need to be
collated in the 'summary sheet headings' (presumably via a vlookup on a
further 'standing data' sheet?). Im sure some VB or macro would do, but am a
total novice at those!
Thanks for any advice!

 

[Guest]

If you use in the dropdown list the name of the worksheets, you can reference
your data using INDIRECT, and it will change with your selection.
Supposing the dropdown is in cell B1, a formula to refer to cell C3 of the
selected worksheet will be:
=INDIRECT(B1 & "!C3")
When you add more headers, changing the cell reference part of the formula
will allow you to link to the new data.

One warning, this will work fine if the format of all the worksheets
referenced is the same. Otherwise, the results will be unpredictable.

Hope this helps,
Miguel.