Hi all,

I am new to this board but have worked in excel for quite some time. Most of my knowledge is with functions and building templates with a little in VBA, so any help on my problem would be much appreciated and hopefully one day I could return the favor.

I am currently working on a sales document for my company. On the first worksheet you will see two tables that are side by side. The first is the document that is pulled weekley; this document contains all information regarding the sale. The other document to the right is the sales document in the companies system which will need to be updated from the newly pasted document to the left. On the second worksheet what I have tried to do is compare the two on the first sheet to get an updated version that I can send back to the system on the second sheet.

What I am looking to do/improve is find a way not only to add in based on the 1st table on the 1st sheet but to update information from the previous document. Pretty much trying to combine the two tables on the first page and update any existing Numbers (1st column in each table) data on the second worksheet.

If anyone could provide any suggestions on how to do so that would be great. This report will be updated weekley and imported back into the system.

Thanks for your help and attached is an example copy of the document.


Best regard,

Patrick Template_Example.xlsx