Hide/Unhide cells based on drop-down list

Hi there,

I'm super new to VBA, but I've got a problem and I believe this is the right place to ask...

Here's an example of what I'm trying to achieve...

Category 1 Category 2 Category 3 Category 4 Drop down menu 1 Drop down menu 2
Sample Location 1 5 4 1 6 Category 1 Category 1
Sample Location 2 2 7 9 1 Category 2 Category 2
Sample Location 3 1 3 5 2 Category 3 Category 3
Sample Location 3 6 1 2 5 Category 4 Category 4

What I'm looking to achieve is to have all Categories hidden, and as you select a category from a dropdown list, it appears, and subsequently disappears if you select a different category from the dropdown list. For example - If you select Category 1 (Cells H5:M5, for all sample locations) in Drop down menu 1 and Category 4 (Cells T5:Z5, for all sample locations) in Drop down menu 2, then have all other categories hidden.

Is this achievable using VBA?

Any direction would be greatly appreciated.

Alex

It didn't format the way I wanted it to, but I hope you get the gist!

Cheers