Create Excel Dashboard for Open Sales Order & Inventory
Budget: $50 – $200 USD
Would like to create an excel dashboard that compares open orders to inventory on hand, subtracting inventory from open orders with totals.
We have 3 basic exports we can do, but need them combined with units of measurement into 1 master tab showing starting on hand and balance after open orders.
Sample sheet attached. Need to find a way for all 3 reports to be auto combined by macro or some clever excel formulas.
We have 3 basic exports we can do, but need them combined with units of measurement into 1 master tab showing starting on hand and balance after open orders.
Sample sheet attached. Need to find a way for all 3 reports to be auto combined by macro or some clever excel formulas.