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 (A52100) 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 A5260 shows but my susbtotal stays at row 101 down below. I want the rest of empty rows from A61100 hidden and when I select "Category B" in Cell B32, it shows data from A5254 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
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 (A52100) 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 A5260 shows but my susbtotal stays at row 101 down below. I want the rest of empty rows from A61100 hidden and when I select "Category B" in Cell B32, it shows data from A5254 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
Last edited by a moderator: