Hi,
I am trying to execute following code, this code matches first 10 characters of two columns and if it matches then it copy and paste it in the workbook.
/code
.Formula = "=VLookup(LEFT(A2,5),'C:\Users\ofatima\Documents\Ivy Woo\[dump_parts_IWoo New.9175.xls]Sheet1'!$A:
/code
it is...