Compare two excel files and hightlight the difference(Macro?VBA?)

i receive two separate excel files done by two parties, so the item name is not the same but actually talking the same thing like the example i attached "Apple" = "Apple_a". But they may count the apple in different time slot. But the total should be the same.

Here is the thing, i want to know if there is any difference between two files number/quantity. As Book1 is sender, Book2 is receiver. Number of In and out should be the same.

Please help. Thanks!!!

please help

1st file names the item as "APPLE" 2nd file names the item as "APPLE_A_01". As they are enter by different user but talking the same item.

Please let me know what i can provide. Many thanks

please kindly help

whatever solutions in excel is fine!
Yes, my goal is to ensure the quantity of two files of each fruit is equal and figure out if there is difference.
a more advance may also consider the which time slot occur the difference of quantity(but maybe just consider the basic part first, as i assume if their total quantity is equal, then fine, if not, there is error)

Many thanks!

both number of apple is 25 ,but how come the result is diff?

---------- Post added at 03:45 AM ---------- Previous post was at 03:38 AM ----------

can index and match be a solution for the case?

please help