Rewrite code to use less memory

I posted this problem a few days ago, here.
Now that I understand the problem a little better, I’m posting it again (hopefully a little clearer)

I have a macro that performes a simple task. It matches rows from sheet2 with rows in sheet1 if their respective value in column A match.
However, when I have a lot of data, I get a memory error and can't run the code.

This is an example of a smal dataset (the line that causes the error):

Please Login or Register  to view this content.

My question: Is there a way to break this up into several separate operations?
E.g. first find matches for row 1 and 2, then row 3 and 4, etc.

I’m stuck, so I appreciate all feedback!

That code extract works for me and generates

Formula:

Please Login or Register  to view this content.

in cell I1, copied across and down to cell M10.

Perfect! This is beautiful

Thanks again, this is very very helpful!

Hi, thanks again!

I'm sure it's faster but I get a memory error on this line (on a laptop)

Please Login or Register  to view this content.

However, you've already reduced my run time from hours to seconds - And I'm very exited about that

I'll try it again tomorrow on a desktop.

Hi again,

Sheet1 has 140 000 rows and goes to column DA
Sheet2 has 250 000 rows and goes to column AK

I might need to work with bigger sheets in the future, but not significantly bigger, so I think this will do it

I ran the quick code again and got the out of memory error, here:

Please Login or Register  to view this content.

I timed Sub KarlK() and Sub KarlKLG() and both used 22 seconds, is the latter better?

Ok, thats good to know.

I'm not sure about the configuration at all - My (work) computer has access to my partition (40GB free) through a network, and I do not have access to the C: drive. System information says 8GB of RAM though.

Anyway, thanks again for taking the time to help!
It makes this project a lot easier for me so I really appreciate it