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