On Sun, 15 Nov 2009 07:43:52 -0800 (PST), Herbert Seidenberg
wrote:

The file shows both methods:
Manual: See the "Advanced Filter" picture.
Macro: See macro linked to "Advanced Filter" button.


So, it still, in each case, requires a manual operation?

Is there no way to have the FlicNum selection I make on my main sheet
cause this filtering to occur dynamically, ie without the need for a
button or user injection of the number?