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?

Howard