T
TK
Hi:
I use a very simple invoice that referances a parts list
with a lookup formula(index/Match Part# PartName
PartCost)
the invoices are then saved with Saved AS under
a customer's name and the original worksheet's parts list
stayed the same.
My problem.
I have added inventory to the list and if a part is sold
it is deducted from parts on hand. All sounds simple
until you consider that the individual customer's
invoices now have the parts sold list.
This is the second post. Debra responded to the first
(thanks Debra) however I could not acomplish what she
suggested.
Any advise or direction will be greatly appreciated.
TK
I use a very simple invoice that referances a parts list
with a lookup formula(index/Match Part# PartName
PartCost)
the invoices are then saved with Saved AS under
a customer's name and the original worksheet's parts list
stayed the same.
My problem.
I have added inventory to the list and if a part is sold
it is deducted from parts on hand. All sounds simple
until you consider that the individual customer's
invoices now have the parts sold list.
This is the second post. Debra responded to the first
(thanks Debra) however I could not acomplish what she
suggested.
Any advise or direction will be greatly appreciated.
TK