Copy entire row to another sheet based on a criteria

  • Thread starter Thread starter Brig Siton
  • Start date Start date
B

Brig Siton

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 said:
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
Click to expand...
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
 
U¿ytkownik "Brig Siton said:
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
Click to expand...

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