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