How to have Excel move a row of data to another worksheet

[Guest]

What is the best way to accomplish the following:

If cell C2) equal C3, duplicate entries that is, copy the two row to another
worksheet in the same workbook?

 

[Debra Dalgleish]

Chip Pearson has information on finding and tagging duplicate entries in
a list.

http://www.cpearson.com/excel/duplicat.htm

After they're tagged, you could apply an AutoFilter, and copy the
visible rows to another sheet. There are instructions for AutoFilter in
Excel's Help, and here:

http://www.contextures.com/xlautofilter01.html

 

[Guest]

Debra,

thanks for your response. I'm would like to do this programatically with VB.

 

[Debra Dalgleish]

If you record the steps as you do this manually, you'll have a good
start on the code.

If you get stuck, post the code that you have, and explain the problem
you're having. Someone may be able to help.