This is an easy one - just having a brain fart.
I have a data validation drop down in a2 with three options: "One", "Two", or "Three"
Range B1:H1 has random values of either "One","Two", or "Three"
What I am looking for is an automatic worksheet code that hides any columns, in the B:H range, that does not match the corresponding Data Validation selection. Looking for the trigger to be anytime the data validation is changed. This would also unhide any columns that does match the validation.
Thanks for any help,
Bookmarks