I need help creating a macro that will unhide rows depending on the # of substances that are selected from the drop down menu.
Cell D90 will contain the drop down menu containing 0, 1, 2, 3, 4, and 5
If 0 is selected then rows 91-100 are hidden
If 1 is selected then rows 93-100 are hidden and 91-92 are unhidden
If 2 is selected then rows 95-100 are hidden and 93-94 are unhidden
If 3 is selected then rows 97-100 are hidden and 95-96 are unhidden
If 4 is selected then rows 99-100 are hidden and 97-98 are unhidden
If 5 is selected all rows are unhidden
There are several tabs in the file and the tab that i want the macro for is the report tab
thanks for any help that is rendered
Using Excel 2010
Bookmarks