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

U¿ytkownik "Brig Siton" napisa³ w wiadomoœci
...
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


apply filter to column you want
then edit-go to-only visible cells
paste selection to wherever u want
mcg
or u want it to be done automatically?
mcg

Thank you very much for your feedback. I was leaning towards doing it
automatically.

Maybe creating the formula to the worksheets where it should go.

Can you help me on that?

Thanks again.

Brig

"Gazeta" wrote in message
...

U¿ytkownik "Brig Siton" napisa³ w wiadomooci
...
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


apply filter to column you want
then edit-go to-only visible cells
paste selection to wherever u want
mcg
or u want it to be done automatically?
mcg

U¿ytkownik "Brig Siton" napisa³ w wiadomoœci
...
Thank you very much for your feedback. I was leaning towards doing it
automatically.

Maybe creating the formula to the worksheets where it should go.

Can you help me on that?

Thanks again.

Brig

"Gazeta" wrote in message
...

U¿ytkownik "Brig Siton" napisa³ w
wiadomooci
...
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


apply filter to column you want
then edit-go to-only visible cells
paste selection to wherever u want
mcg
or u want it to be done automatically?
mcg




easiest way is to record macro on doing what u want
i mean when ur done with filter - record macro
mcg