HOW CAN I AUTOMATE FILTER?

S

Sarena

I have drop down filter lists created over each column. Within each list I
have customized the filter option. After having these custom filters set up,
I would the lists to automatically filter themselves every time I refresh my
data and/or open the worksheet...(without me having to go to each list and
select the custom filter option in each list)? PLEASE HELP!

Also, I think if someone can tell me how to make a macro and then just have
it automatically run without me having to push the macro button....that can
be another way for me to accomplish what i am trying to. Thank you!
 
Top