View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
capxc capxc is offline
external usenet poster
 
Posts: 37
Default Comparing and Reconciling 2 excel tables

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