inventory this

[TK]

Hi:
I use a very simple invoice that referances a list with a
lookup formula(index/Match)
Part# PartName PartCost
the invoices are then saved with Saved AS of course under
a customer name and the original worksheet's list stay
the same.
My question. I would like to add inventory to the list
and if a part is sold deduct it from the original
worksheet's list. All sounds simple until you consider
that the individual invoices have the parts sold
list.
Any advise or direction will be greatly
appreciated
TK

 

[Debra Dalgleish]

The original file could contain an invoice sheet, with blank input
cells, a parts list, and an inventory list.

After you fill in the invoice sheet, you could use a macro to copy the
invoice information to the inventory list.
Then, the macro would copy the Invoice sheet, as values, to a new
workbook, clear the input cells in the original file and save the
original file.