Copy Rows meeting a condition but not duplicate

**taichi56** · 01-16-2009, 06:09 PM

I got this code form Ozgrid that works great other than everytime I run the macro it copies everything over again.

Please Login or Register  to view this content.

What do I put in my code so it does not duplicate? Other words I run the macro once and it finds all the "Yes". Then I input some more "Yes" and run it again. Now it has copied everything even the same ones from the first copy. Please advise. Thank you.

**VBA Noob** · 01-16-2009, 06:20 PM

Maybe add a line to delete sheet2 first then add a blank sheet named Sheet2

VBA Noob

**taichi56** · 01-16-2009, 08:45 PM

I tried some different deleting codes but did not seem to work. It would just hang up and copy 4 rows of data up to 2500 rows.

**VBA Noob** · 01-17-2009, 04:37 AM

Maybe

Please Login or Register  to view this content.

VBA Noob

Copy Rows meeting a condition but not duplicate

LinkBack

Thread Tools

Rate This Thread

Display

Copy Rows meeting a condition but not duplicate

Copy Rows meeting a condition but not duplicate

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions