Excel VBA - Filter and Copy rows based on input box

[nigelapt]

Hi Everyone
Be grateful for any advice on the following:

I have a worksheet detailing all the items invoiced to each customer which is downloaded from our accounts system daily. The sheet is sorted by invoice no/product. The invoice number can relate to many different rows within the sheet. As I need to be able to select more than 2 invoice numbers, the custom autofilter is no use.
Is there anyway I can prompt users to enter in a range of invoice numbers, and then filter and copy the results into a new worksheet?

Thanks!

Nigel

 

[PHV]

You may still use the autofilter stuff with 2 conditions ANDed (>=minNunmer AND <=maxNumber)

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[VBAjedi]

Hi Nigel!

I have accomplished something similar using the Advanced Filter (AdF). The AdF considers each criteria line to be a "set" of conditions, so if you have, say, 5 criteria rows, the AdF will return all data rows that match any of the 5 criteria rows.

See my last post in thread707-811281 for more details on how to implement it.

Let me know if that helps!

VBAjedi