From: Tator Bug Tator on 25 May 2010 16:11 I have a sales receipt worksheet that has all my sales items on it. I also have an inventory worksheet. I would like when I make a sale that it automatically is deducted from my inventory worksheet. I have Office 2003 Example: Sales receipt is (sheet 4) In each column Item#-Description-Item Cost-Qty-Cost Example: Inventory is (sheet 5) In each column Item#-Description-Cost- Qty Rec'd-Sold-In Stock
|
Pages: 1 Prev: Function to add name of Sheet to a Column? Next: Array formulae do not recalculate |