I am mediocre when it comes to macros. I have a worksheet named Select and it has several data validation lists in it. Another worksheet called Billings Data has autofilters. I want to run through the options in the data valdation lists and then turn several autofilters if the data validation list is not "All". I have tried several different ways and I have not been successful. The if statement doesn't seem to recognize the <>"All" and I want it to run through and check all statements below. Skipping to the next statement if "All" is in the data validation lists on the Select worksheet (below).
Geo Consol Country Country Product Market Product Type Product Family
Americas ALL ALL ALL ALL ALL
Macro
Any help would be greatly appreciated.
Bookmarks