several links to filtered list each with differenct criteria

  • Thread starter Thread starter David_GH
  • Start date Start date
D

David_GH

Hello- I'd like to be able to create _several_ (hyper)links to _one_ set of
data, with each link providing a different filtered view of the data. The
"AutoFilter" functionality can display the data in the way I'd like to see
it, but needs the filter criterion to be selected from the dropdown manually.
By clicking on the link, I'd like to arrive at the data with the particular
filter associated with the link already applied.
In SQL, it would be like a SELECT * WHERE (criteria)
Sorry if this is a trivial question!
Thanks, and all the best.
 
Instead of using hyperlinks, why not use macros...
"record new macro" while you perform your autofilter. Then, make a button
(forms toolbar), and assign the macro to that button (or simply assign it a
keyboard shortcut, which is an option in the box when you name the macro).
Running the macro should run the filter, and you can then make a separate
macro for each filter of the data.
 
Back
Top