Using an array with multiple criteria

[anthony1312002]

Hey everyone, The array below works very quickly. But what I would like to do is add 3 criteria to it so that it only copies what the criteria specifies. What would I need to do to make this possible?

Criteria 1 = Category
Criteria 2 = StartingDate
Criteria 3 = EndingDate

Please Login or Register  to view this content.

[torachan]

The attached is one method I have used in the past.
I needed to test capacity/speed in anticipation of app after 5 years use.
It basically sorts invoicing from a transaction history, based on start date > end date > account name.
To test seed the array with multiples of the existing data (say 10,000 or 100,000 rows).
The basics of the code are the rows that do not satisfy the parameters are filled with blanks then the blank rows removed.
The workhorse of the code is between the two long rows of asterisks.
If you upload a desensitised example of your workbook I can then apply the code to demonstrate.

[anthony1312002]

Thank you so much! I'm going to make a go of this.

[Marc L]

[…] so that it only copies what the criteria specifies.

Hi,

obviously just use filters or better an advanced filter …