Hey guys, it has been a while since I have been here and normally I manage to create working codes for documents with help of the information on the forum but at the moment I am stuck and can't seem to find a good code to do what I want. I have two worksheets with data which are a dumps form our ERP software, I have imported the excel data into two sheets and placed them in tables (one sheet, one table). The data contains items which still have to be purchased and parts that have already been ordered, some of these parts have an order acknowledgement (OA) and some are still pending for an OA. To keep a good overview of which items still need to be purchased or still have to be followed up for an OA, I would like to load a new dump from our ERP and compare it with the last dump (let's say a week before). The new data will be imported on sheet 1 and the historic data can be found on sheet 2. I would like to check which rows of the new dump are present in the table on sheet 2 and if so, see what items have been changed. Important is to check if values of 3 different columns in table 1 are present in table 2, only then this row item is the same item as in table 2. Please note that the rows can be anywere, so row number 3 on sheet 1 can correspond with row 10 on sheet 2. [ATTACH=CONFIG]73313[/ATTACH] [ATTACH=CONFIG]73314[/ATTACH] The first image shows the table on sheet 2 with historic dates, the second image shows the table with the new dump on sheet 1. In yellow the columns are highlighted which will need te be used to check if data from 1 row in table 1 is present in table 2 on sheet 2. In the second image you see that particular cells are highlighted, these cells contain data which is different (blue) or a complete row that is not present in the historic data (red). I have tried a lot of codes but cannot figure out the correct approach. See below the code I have ended up with, but maybe a different approach would be better. (Code, 65 lines) Hopefully you can help me out with the code, I have been trying for a few days. Your help is appreciated! Best, Ruud

VBA code to compare data of two tables on different worksheets

Don’t have an account yet? Register yourself now and be a part of our community!

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.