Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. -- Anne Murray "David_GH" wrote: 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UPDATING CELLS THAT HAVE BEEN CONNECTED FROM DIFFERENCT PAGES | Excel Discussion (Misc queries) | |||
Count Filtered Visible Items that Match Numeric Criteria between two ranges | Excel Worksheet Functions | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
Future Value function with differenct cash flows | Excel Discussion (Misc queries) | |||
How can I count cells that meet two criteria within a filtered co. | Excel Worksheet Functions |