Hi,
I was hoping for some assistance to create a code for the following purpose.
I have created a drop down list in cell B1 with 24 text options, for ease of assistance, lets say AAA through XXX. I will be importing data from another program into row 6 to 400. I would like to hide all rows excluding those rows that show the same text as the drop down selection in cell B1. So if cell B1 reads 'AAA' I would like all rows between 6 to 400 to be hidden if they do not read exactly 'AAA' If the drop down box was then changed to 'BBB" I would like to only display 'BBB" and hide all other text in row 6 to 400.
I've tried a few options however my skill level is not overly high with VBA. If I could get some assistance that would be highly appreciated.
I was hoping for some assistance to create a code for the following purpose.
I have created a drop down list in cell B1 with 24 text options, for ease of assistance, lets say AAA through XXX. I will be importing data from another program into row 6 to 400. I would like to hide all rows excluding those rows that show the same text as the drop down selection in cell B1. So if cell B1 reads 'AAA' I would like all rows between 6 to 400 to be hidden if they do not read exactly 'AAA' If the drop down box was then changed to 'BBB" I would like to only display 'BBB" and hide all other text in row 6 to 400.
I've tried a few options however my skill level is not overly high with VBA. If I could get some assistance that would be highly appreciated.