Hello, I'm rather new to Excel and VBA programming, but being a C+
programmer has helped me a little bit. I've got two spreadsheets wit
duplicate employee id columns (col G and Z) and phone number column
(col H and AA). Only the AA phone number column has data and I need t
move it to the other column based on matching columns G and Z. I wrot
this little bit of code, but it's not working? Can someone pleas
point me in the right direction. Thanks!

Sub Fixit()
Dim i As Integer
Dim j As Integer

For i = 2 To 3261
For j = 10 To 6510
If Cells(i, Z).Value = Cells(j, G).Value Then _
Cells(i, H).Value = Cells(j, AA).Value
Next j
Next i
End Sub

Justin Robinson


** You'll notice the Z/AA columns are smaller in size

--
panuvi
-----------------------------------------------------------------------
panuvin's Profile: http://www.excelforum.com/member.php...fo&userid=2381
View this thread: http://www.excelforum.com/showthread.php?threadid=37466