Quote Originally Posted by cloudwalking View Post
That's amazing! Thank you so much! The only (very small) issue I have is that the range I'm copying has 14997 rows (A3:A15000). So I think I did the correct thing by setting the Resize(14997)? But obviously this takes a bit of time to process.

About 500 per time produce data. I have looked into using 'Special Cells' but am not entirely sure if they are appropriate, or how to implement them. Is this or any other way worth investigating in order to speed up the macro? (I already turn off screen updating and calculation before running it)
You're welcome.

A3:A15000 = 14998 rows

This should take practically no time (sub-second) to copy the values.
Found.Offset(1).Resize(14998).Value = Range("A3:A15000").Value


I didn't understand what this means;"About 500 per time produce data. "