verify 2 sheet value and return different value to result sheet.

hi all, have any idea using VBA for verify two sheet data if it is differect will copy and paste the value to result sheet in TYPE column base on the different value such as Part number,ID ,category or quantity.moreover,attached excel document is a outcome example.



Thanks and regards,
Kinder.

This formula based proposal employs numerous helper columns which may be moved and/or hidden for aesthetic purposes.
Note that there are no differences between the records for ID's 1006, 1008 and 1009 so I can't help you there.
1) Columns G:J on the original sheet identify the first difference in ID, Part No, Category and Quantity for an ID between the original and sub sheets using formulas like:

Formula:

Please Login or Register  to view this content.

2) Column G on the Sub sheet identifies New Data using:

Formula:

Please Login or Register  to view this content.

3) The range A10:E15 on the Compare Result sheet is populated using:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.