Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show data dependant on selection from drop down box
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show data dependant on selection from drop down box
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. "ukplay" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) |