0

The macro below loops through column E in Sheet2 and finds matches in column Z of Sheet1. If a match is found it copies the value on the same row contained in column AA.
It works ok but hangs when it runs. There are usually a few thousand values in column E but less than 30 in column Z.
I've run ...