advanced filter

  • Thread starter Thread starter Wayne Burritt
  • Start date Start date
W

Wayne Burritt

Hi all: I'm using advanced filter on a lot of data and I'd like to speed up
the process a little. I would like the list to sort automatically after
enter data into my criteria field(s) instead of having to click on advanced
filter every time and run the search. Any ideas?



Wayne
 
I run mine after entering criteria data in about 12 cells and then hit a
button which I've set up with a recorded macro to start.........maybe you
could get some VB-savvy person to write you a quick macro that will start
the advanced filter as soon as you enter data in the last cell and hit
Enter.....I think they call it a "Change event" macro, or something like
that......

Vaya con Dios,
Chuck, CABGx3
 
Back
Top