fareedexcel
Member
Hi,
I have a workbook with Two Sheets namely old and New Sheet which has employee records. I need to compare both the sheets and find the difference as per the column header and the differences count to be captured in the Summary Sheet.
I have attached a sample file for reference. Kindly help.
Note - In both the sheets Master data will be not equal and the rows may vary. New Sheet data to be looked up with the old sheet data and say the count differences. I tried with Sum product but it's not helping, as the requirement is to match against the erp number from New sheet to Old Sheet records.
I have a workbook with Two Sheets namely old and New Sheet which has employee records. I need to compare both the sheets and find the difference as per the column header and the differences count to be captured in the Summary Sheet.
I have attached a sample file for reference. Kindly help.
Note - In both the sheets Master data will be not equal and the rows may vary. New Sheet data to be looked up with the old sheet data and say the count differences. I tried with Sum product but it's not helping, as the requirement is to match against the erp number from New sheet to Old Sheet records.