Ideas for Macro to add lines from 1 Excel to Another one

Hi Guys,

I have a excel called Base and another excel called File to be added.

I want to add the lines from File to be added to Base but if the lines from File to be added are the same in Base please discard add the lines and only add the lines that are not in common based in column A "kEY"

Attached files File to be added.xlsxBase.xlsx

If you can bring me any light to know how to start with this could be amazing

An idea,

Assuming both workbooks are in then same folder.
File to be added.xlsx must be closed.

Please Login or Register  to view this content.

Originally Posted by davesexcel

Try this

Please Login or Register  to view this content.

thanks a lot this works very good !!

Originally Posted by jindon

An idea,

Assuming both workbooks are in then same folder.
File to be added.xlsx must be closed.

Please Login or Register  to view this content.

This is amazing with that I can continue with my macro . Help a lot !!!