Yes, but Luke advised you earlier that you can record a macro while
you do it once, assign a button (or hot-key) to that macro, and then
just re-run the macro when you need to.
Hope this helps.
Pete
On Sep 17, 12:54*am, "golddave" <u54833@uwe wrote:
I also need it to dynamically update since it's going to be used by non-
technical people who can't be expected to run the filter mechanism.
Pete_UK wrote:
Take a look at Debra Dalgleish's site he
http://www.contextures.com/xladvfilter01.html#FilterUR
She shows how you can use Advanced Filter to get a list of unique
values.
Hope this helps.
Pete
I've tried Advanced Filter several different ways and have not been able to
get it to work.
[quoted text clipped - 14 lines]
- Show quoted text -- Hide quoted text -
- Show quoted text -