Copying unique records to Main worksheet in Excel VBA

[hariexcel1987]

Dear Team,

I am working in excel vba to copy a unique records and paste to Main worksheet

Here i have 2 sheets(1. Editable Pipeline data(Main Sheet) 2. Trace inputs ) so here i want to compare my Editable Pipeline data with Trace inputs and copy unique data values and paste into end of the cells of Main sheet (editable pipeline data)

2nd step is do the vlookup from the Editable data to Trace inputs and fetch the other related info


below is the code , here i am getting error becoz i am extending cell range, so please help here

sample excel sheet also attached please help

please help, here is the record macro

Please Login or Register  to view this content.