M Merlin Jan 10, 2004 #1 I am trying to build a stock control sheet is there a method or formul for updating a cell every time stock is removed
I am trying to build a stock control sheet is there a method or formul for updating a cell every time stock is removed
G Gord Dibben Jan 10, 2004 #2 Merlin Without knowing your layout, hard to say what you need. Simple terms......A1 holds Starting Inventory, B1 holds Items Sold, C1 has this fomula =A1-B1 Gord Dibben Excel MVP
Merlin Without knowing your layout, hard to say what you need. Simple terms......A1 holds Starting Inventory, B1 holds Items Sold, C1 has this fomula =A1-B1 Gord Dibben Excel MVP
