Search and Find Macro runs too slow

[Jietoh]

Hello All!

So I wrote the following code to run on a button click. Essentially, I want to to loop through a column of data until the end. For each cell that has data it will search for a match in another column on another worksheet. If a match is found various cells adjacent to it are copied and brought back to the first worksheet and pasted alongside the original cell.

I got all of this working fine, however, it takes too long to run. I have a list of over 2000 items, and after running for 2 minutes the code only got through 200 lines. Can you help me speed it up at all?

Please Login or Register  to view this content.

[HerryMarkowitz]

Your code can not to be faster...
But, we can supply another way if you can attach your file...