I have attached an excel workbook which contains the following 5 worksheets:
4. In PO but not in RO
5. In RO but not in PO
I am looking for a macro or small software/script which can take the values in Worksheets 1 (PO) and 2 (RO) and compare the 'TOTAL' column value for a company using its unique code and/or name.
Based on the results of the two sheets a report is to be generated in one of the next three worksheets.
In the 'RESULTS' worksheet if the unique code and/or name, and total value is found in both sheets (PO & RO) then we want to show the values here regardless of the total values being matched or not. Maybe we can show a Y/N value in the 'Total Mismatch?' column. Y for "Yes, there is a mismatch in the total values" and N for "No, both values are equal".
In the following two worksheets it's pretty straightforward. Any unique code, name, and total that is found in one of the sheets and not in the other is to be produced in these two sheets, respectively.
**IF PROVIDING A MACRO THEN KINDLY PROVIDE A STRONG DOCUMENTATION AS IT WILL MAKE UNDERSTANDING THE CODE EASIER**