Forum Discussion
Using A Dropdown List To Organize Hidden Rows
I am looking for a way to hide entire rows, but use a drop down list in a specified cell where I can choose which row to make visible when needed.
For example if I hide rows 5-16, and I want to unhide row 7, I would like to select a drop down list and pick row 7 to open.
Additionally it would be nice if I could keep it open while I pick other rows in case I need to do any comparisons on the data.
Is there any way to do with this without macros/ VBA or no? If I have to I can, but I would prefer everything be straightforward functions rather than scripting.
6 Replies
tzaharia Good and bad news. Unfortunately, this can only be done using VBA.
Good news - the scripting is very simple and easy to understand. If you can attach the workbook, without any sensitive data, with the format intact and let us know the exact rows you want hidden, a script can be written shortly.
tzaharia Here are some notes on the changes made:
1. The workbook has been saved from .xlsx to .xlsm to host the VBA/macros since it needs to be Macro-enabled
2. The yellow box is where you input the row to be unhidden, with the Unhide button to active the function
3. The view the VBA, click Alt + F11 and you'll be to see them in Module1
