I have 2 reports - one from "Sales", another from "Inventory". I want to develop a quick and easy way to reconcile them every day (i.e. macro would be ideal).
Here's the data after my first macro -
If you compare the 2 reports, you'll see that they don't match at first glance. That's because the sales report shows individual items, whereas the inventory report also combines a few of those products and creates a new SKU.
The end results I'm looking for is this:
What's the best way to compile these? Macro? Pivot? Lookup? Array? If/Then? I'll take any and all ideas....
I can attach the workbook if someone wants to try and take a crack at it....
Here's the data after my first macro -

If you compare the 2 reports, you'll see that they don't match at first glance. That's because the sales report shows individual items, whereas the inventory report also combines a few of those products and creates a new SKU.

The end results I'm looking for is this:

What's the best way to compile these? Macro? Pivot? Lookup? Array? If/Then? I'll take any and all ideas....
I can attach the workbook if someone wants to try and take a crack at it....
