Excel/Unhide sheet only Selected option from drop down list
I am stuck to a problem, seeking help from the experts.
Having first sheet named as Data, where I have two drop down list
Grade: m4a,m4b,m5 ....
Location: Factory, Region...
Again, having 10 more sheets as such:
... and so
Now I want to unhide and make active only that sheet, which I select from the data sheet drop down.
Example: If I select M4A from Grade dropdown and Region from Location dropdown, then M4A_Region should get unhide and active and rest will be hidden.
Thanks in advance,
Sample Sheet is enclosed. - SampleWorkbook.xlsx
This can be handled by using a macro. You could write a quick macro which can work on "Case"
Select Case = M4A
hide sheet 1, sheet 2
case = M4x
hide sheet 3, sheet 4
If you are ok with this, please send me all the drop down values and sheet names and I can write a macro and send it across.
One more question - Do you expect more sheets to be added in future? if yes, then you might want to consider that while building this macro.
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here