I need to hide different rows based on a cell value.
The target cell will always be the same, but there are eight different values in the drop down list in the cell.
I am using Worksheet Change in VBA but it is not working
Note: A user may select a value from the drop down list in the Target Cell, but may then change their mind and select another value.
I need only the rows hidden for the selection chosen in the drop down list.
All other rows should be shown.
Following is a sample of code I am trying to use
When selecting NEW PHONE & MOBILE NUMBER, rows 26:32 are hidden as expected, but if I then change the selection in the target cell to DATACARD FOR LAPTOP only rows 24:26 are hidden. Rows 27:32 are not hidden