Find&Copy only copying 1 instance of match

**SarahPintal** · 07-13-2010, 10:15 PM

Hi guys,

Can someone please tell me how to get my below code to not copy 1 match of the inputed item, rather all of them.

At the moment if i enter 'Sarah' only 1 sarah is found when in reality sarah appears many times, though only 1 row is being copied with it.

Thanks in advance,

Please Login or Register  to view this content.

**JBeaucaire** · 07-13-2010, 10:58 PM

Try this:

Please Login or Register  to view this content.

**SarahPintal** · 07-13-2010, 11:26 PM

Hi JB,

It find all of them now though does not break out of the loop... i had to break out and when i looked at the results there was over 1000 lines, with about 100 instances of the same line.

**JBeaucaire** · 07-13-2010, 11:45 PM

Time to post a sample workbook so we can see this stuff together. Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

**SarahPintal** · 07-13-2010, 11:58 PM

Sure thing; It is the second last sub.

I have put dummy data into the report...

thanks again

**JBeaucaire** · 07-14-2010, 02:41 AM

what's the password?

**JBeaucaire** · 07-14-2010, 02:57 AM

Nevermind, I think an AutoFilter is a much faster method. Try this instead:

Please Login or Register  to view this content.

**SarahPintal** · 07-14-2010, 06:37 AM

Worked like a charm - ill try my best to learn how you did this as this was very quick and clean compared to my find subs.

Thanks

**JBeaucaire** · 07-14-2010, 10:55 AM

When evaluating the SAME column row by row, cell by cell for the same value, it's much faster to simply turn on the Data > Filter > AutoFilter and filter that column by the value you're searching for. Once the AutoFilter is on, non-matching rows are hidden so you can literally just copy the whole range and it will ignore the hidden rows...very cool, and much faster overall.

Play around manually with the AutoFilter so you can see all the various things you can do with it.

Cheers.