Hi everyone!
We need to match records between 2 worksheets using column "K" in both sheets. It contains a unique item number for each record (like a database)

Using a loop, if the active cell in column D of worksheet1 is blank, then the value in column D in worksheet2 is printed to the cell in worksheet1 where the cell in column K are the same in both worksheets.

Dim i As Long

For i = 7 To lastRow
If Cells(i, "D").Value = "" And Cells(i, "K").Value = 'Value in column "K" of worksheet2 Then
Cells(i, "D").Value = 'Value from the cell in column "D" of worksheet2
End If
Next i

Thanks in advance everyone!