Sir
i m looking a macro for my project..

Where 2 excel workbook (Ex, workbook1 & workbook2 )..

We want to copy data from workbook 2 to workbook 1

in workkbook1 Sheet name (RD-1)
in workkbook2 Sheet name (RD-2)

Workbook1 (Sheet RD-1)

A B C D
item1 10 12 120
item2 5 8 40
item3 15 6 90



Workbook2 (Sheet RD-2)
A B C D
item1 10 12 120
item2 5 8 40
item3 15 6 90
item4 20 10 200
item5 170 5 850
item6 15 5 75



After Run Macro Resulted Workbook1 (Sheet RD-1)
A B C D
item1 10 12 120
item2 5 8 40
item3 15 6 90
item4 20 10 200
item5 170 5 850
item6 15 5 75



Actually if workbook2 item already add in workboko1 then then record not copy... in examle only copy item 4,5,6 coz itme 1,2,3 already in workbook1


hope u friends & forum guru help me solve this problem..

Thanks in advance

Santosh