Hi how do I hide rows from a sheet based on a drop down list in another sheet in the same workbook?
I have 2 spreadsheets:
"MENU" with the dropdown list "Project Status Report" and "Project Closure Report" and
"3. Report" in which the hidden rows will be: Rows 132 to 185 if "Project Status Report" is selected and Rows 102 to 130 if "Project Closure Report is selected"
Thanks!
Regards
Bookmarks