Hi Howard,

Am Sun, 22 Nov 2015 12:57:45 -0800 (PST) schrieb L. Howard:

Say the sheet has these headers, with maybe 100 - 150 + or so rows of data.

PO_No. Invoice Page Line Ref Description Qty (Column A - G)

Users will not be trusted to use Auto Filter from the sheet to do the following.

A user has Invoice, Line & Qty info. Find all rows that match those three criteria, return Entire Row Data to sheet 2. Where Entire Row Data is from column A to G.

Next user has Invoice, Ref, Description & Qty. Now find/return all rows that match those four items to sheet 2. (Below last entry)

A user has only the Invoice. Return all rows with a Invoice value.

Can code work with a variable number of "Filter By" choices, especially with choices that will be different almost every time as well as the number of header choices?

Or an InputBox would be okay for the users. I think the order of the headers and the order of the data to the InputBox is not really important, right?

that is a case for a advanced filter. Create the criteria range on
sheet2. And with Worksheet_Change Event you can fire this filter when
users enter the criteria into the criteria range.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional