We regularly receiving inventory update .And it is a huge list.

Question 1 : how do we compare and reconcile the previous inventory xcl
table (OldInv)) with the new inventory update xcl table(NewInv) so that we
could figure out which sku is new in NewInv and was not present in OldInv?

Question 2: how do we compare and reconcile the previous inventory xcl table
(OldInv)) with the new inventory update xcl table(NewInv) so that we could
point out which sku (columns B) inventory turned to zero in quantity
(columns E)?

Can it be done?

Please share your suggestions.

Sincerely,

--
capxc