User Profile
Jshannon1755
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Auto HIDE ROWS based on 2 cells
Hi Community; I have an Excel Sheet for inventory with a column indicating status: 'A' = active, 'IN' = inactive units. I would like to hide/ unhide individual rows based on their status and a drop down list in cell B2 'SHOW' or 'HIDE'. I have seen many post about selecting specific cells, but not a dynamic range based on the show hide value and a column value in the row as in my description above. How to accomplish this, especially when rows are added for new inventory? Cell B2 drop down list SHOW or HIDE inactive units. Column B is the status A or IN Rows 4 - infinity are the individual inventory items There are rows at the top (Row 1,-2) and bottom (Row 44-48) of the sheet which should not be included in the HIDE / UNHIDE Range, containing text labels and instructions. Currently, Rows 4-42 are populated with inventory. I can place a blank copy/paste row at the bottom (currently row 43) if custom formulas or formatting need to be added to cells in a row in order to accommodate adding a new row to the inventory range. Any assistance is appreciated.
