I have a macro that works fine on a sheet containing 3,000 rows yet on another that contains 20,000 rows it fails.
Can someone advise a way to enhance this macro or why it fails?
The macro has to search sheet1 for a specific name in a field (E.g. John) and then copy that row into sheet2 then return to sheet1 and find the next occurrence of the name "John". It then again copies that row and then return to sheet2 and adds that row on the row below the last.
Simply put the purpose is to extract all rows from columnA that contain "John" and paste them into sheet2.
Here is the macro I have been using:
Many thanks for any help or answers.
Thanks for the tips too!