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!


--
mthomas
------------------------------------------------------------------------
mthomas's Profile: http://www.excelforum.com/member.php...o&userid=25649
View this thread: http://www.excelforum.com/showthread...hreadid=467564