Hi,
I want to Hide or Show rows based on criteria.
I have a drop down selection in D4 in the sheet jimmy that allows to select date Dec-12 to Dec-16 (mmm-yy) This list corresponds with values in column in the range b9:b500 in the same sheet. I want to hide every row except for those where D4 matches the value in column B. can any one advice a VBA code for this.
Thanks in advance
Abdul.
I want to Hide or Show rows based on criteria.
I have a drop down selection in D4 in the sheet jimmy that allows to select date Dec-12 to Dec-16 (mmm-yy) This list corresponds with values in column in the range b9:b500 in the same sheet. I want to hide every row except for those where D4 matches the value in column B. can any one advice a VBA code for this.
Thanks in advance
Abdul.