I have 2 sheets: one with Inventory for a day (8/30) and another with sales for the month with dates as 9/4, 9/7. etc.
I would like to merge the two sheets so I can have a running total of inventory by taking the Inventory as of 8/30 and subtracting each day of sale invoices.
I would then like to make a pivot table for easy display. Eventually I would like to create a macro but am still learning how to edit the VBA to consistently get results.
My problem is that the Inventory list is ~650 Items and the sales invoices do not nearly include all of them. I've tried to create a running total with inventory in one column and columns of sale dates in a table but it just seems like there is a lot of errors that I can't troubleshoot.
I am also using Mac Excel which is adding to my frustration as I am a Windows user.
Thanks in advance.
I would like to merge the two sheets so I can have a running total of inventory by taking the Inventory as of 8/30 and subtracting each day of sale invoices.
I would then like to make a pivot table for easy display. Eventually I would like to create a macro but am still learning how to edit the VBA to consistently get results.
My problem is that the Inventory list is ~650 Items and the sales invoices do not nearly include all of them. I've tried to create a running total with inventory in one column and columns of sale dates in a table but it just seems like there is a lot of errors that I can't troubleshoot.
I am also using Mac Excel which is adding to my frustration as I am a Windows user.
Thanks in advance.
