We have an excel file with thousands of rows that is being generated each
month.

This file has a list of letters sent out to our members and the type of
letters with a 2 digit code.

We need to segragate these group of members by the type of letter we sent
out.

The recordset looks like this: FName, LName, Address, City, State, Zip,
LetterDate, LetterType

Is there a way to copy the row, if the letter type meets the criteria we
define?

For examble, if the letter type is A1, the function will go through the
entire worksheet and only copy the rows that has A1 as the letter type.

Thank you very much in advance.

Brig