How can I Invoke a filter automatically

  • Thread starter Thread starter busyman5_au
  • Start date Start date
B

busyman5_au

I have used a filter and list formatting to create the worksheet the way
I want it and the data refreshes (from external links) when I open the
workbook.

But the advanced filter has not been applied.. it works if I click on
it in the menu bar.

How can I re-apply this filter automatically when The data is refreshed
?

Thanks
 
You might just record a macro while going through the steps to activate the
filter, and then just run the macro when the updating is completed.

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top