Rewrite code to use less memory

[Karl Gustaf Karsten]

I posted this problem a few days ago, here.
Now that I understand the problem a little better, I知 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):

Sub Merge_Data()
'Merges the data (rows) with identical Unique-ID - Import from Sheet2 into Sheet1.

Application.ScreenUpdating = False
        
        Temp = "" & "I" & "1:" & Cells(10, 13).Address
        Sheets("Sheet1").Range(Temp).FormulaR1C1 = _
                "=OFFSET(Sheet2!R1C[" & -8 & "],MATCH(RC1,Sheet2!R1C1:R" & 10 & "C1,0)-1,0)"

Application.ScreenUpdating = True
      
End Sub

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知 stuck, so I appreciate all feedback!