Advanced filter and Autofilter can both be implemented in code.

--
Regards,
Tom Ogilvy

lothario wrote in message
...

I understand that autofilter and advanced filter is relevant here.

I cannot use autofilter or advanced filter because
this spreadsheet is used about 50 times a day and it is very
inconvenient to click thru several menu items to do the
same singular task. It becomes a lot easier if I incorporate VBA
code behind a button and have the user click the
button just once to trigger multiple successive events.
As you can see I need multiple criteria to be satisfied.
So VBA code would be the fastest. (I think.)

I appreciate your help.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements