is this code correct ??

[kshitij_dch]

If Not ID Is Nothing Then
sh2.Range("I" & ID.Row) = sh1.Range("J" & c.Row) .paste
End If
Next

 

[Norie]

Only thing wrong I can see is the .paste, which you should remove.

 

[kshitij_dch]

basically i want to do this


Hi all
i have 2 workbooks

wb1(mi report.xlsx ) and wb2(stafftime.xlsx)

wb1 has 2 columns Column "H" (ID"S) and column "I" (Durations)

wb2 has 2 columns column "E"(ID"S) and column "I" (durations)

want a macro which will pick column H and I of WB1 and open WB2 match the ID'S of column H with list if ID"S in column E of WB2, in front matched ID"S in WB2 , Column I(durations) of wb1 gets pasted in column J of WB2.

 

[Norie]

Is this a new question?