Hi. I am running into an issue where I need to compare 2 worksheets for inventory changes and product differences. Every formula I have tried has erred on me and I am hoping someone can help as I have been at this for several months. I am visually blind so comparing over 10k lines manually on a daily basis is impossible. Explanation:
I have 2 sheets (worksheet A & B) that have product information, daily inventory count, SKU etc.
I need to compare the 2 sheets for removed or added products and those to be sent to a 3rd sheet. (Worksheet C) AS WELL AS any inventory of products that has become 0. (Need items to show there is a drop of inventory to zero)
Can anyone guide me into a better formula that will help?
I have 2 sheets (worksheet A & B) that have product information, daily inventory count, SKU etc.
I need to compare the 2 sheets for removed or added products and those to be sent to a 3rd sheet. (Worksheet C) AS WELL AS any inventory of products that has become 0. (Need items to show there is a drop of inventory to zero)
Can anyone guide me into a better formula that will help?
