Hide and Unhide rows based on dropdown list

rahiljaved

New member
Joined
Oct 12, 2017
Messages
22
Reaction score
0
Points
0
Excel Version(s)
2013
Hi
I have tried various codes but either it just hide and never unhide when the value change from dropdown or either it doesn't work.
Situation: I have a dropdown list (Cell B32) have 5 different categories in that and based on that list my data populates in table (A52:D100) using Index and match function at the table. In last row of the data (row 101) I have subtotal of the table. Now, I when I select B32, I want the data to be changed which it does for example: when the cell value shows "Category A" in cell B32, the data range from A52:D60 shows but my susbtotal stays at row 101 down below. I want the rest of empty rows from A61:D100 hidden and when I select "Category B" in Cell B32, it shows data from A52:D54 and again the subtotal rows stays at 101 which I want to come up to row 55 by hiding rest of empty rows. Please let me know if you have a solution.

Thanks in advance


b.PNG

a.PNG
 
Last edited by a moderator:

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,154
Reaction score
3
Points
38
Excel Version(s)
365
A workbook please rather than a picture of one.
 
Top