Hi everyone,
I'm not very knowledgeable about how macros work so I was wondering if any of you knew how to do this.
The firm I am employed by has an e-commerce store which I run. Unfortunately the e-commerce software we use is a bit lacking in the reports function, so I set up a customized spreadsheet to track sales and shipping margins. The spreadsheet is set up to track orders for every invoice. It looks like
Item 30000001 30000002
Widget 1 1 2
Widget 2 0 3
I also have an inventory spreadsheet set up with the items in rows and their quantities, costs, etc. in the columns.
What I would like is a macro that subtracts the quantity sold from the remaining stock as described in the inventory spreadsheet. The issue is that some of our items are bundles that include items that are sold separately, some of which being shirts of different sizes. I need a way to account for the bundle sales in the inventory spreadsheet as well.
I'm not very knowledgeable about how macros work so I was wondering if any of you knew how to do this.
The firm I am employed by has an e-commerce store which I run. Unfortunately the e-commerce software we use is a bit lacking in the reports function, so I set up a customized spreadsheet to track sales and shipping margins. The spreadsheet is set up to track orders for every invoice. It looks like
Item 30000001 30000002
Widget 1 1 2
Widget 2 0 3
I also have an inventory spreadsheet set up with the items in rows and their quantities, costs, etc. in the columns.
What I would like is a macro that subtracts the quantity sold from the remaining stock as described in the inventory spreadsheet. The issue is that some of our items are bundles that include items that are sold separately, some of which being shirts of different sizes. I need a way to account for the bundle sales in the inventory spreadsheet as well.
