View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chip_pyp
 
Posts: n/a
Default Simple Formula Question

I am developing a spreadsheet for an inventory i have of parts. In this
spreadsheet I have the quanity of each part. On another page in the workbook
I have a list of which part were taken from the inventroy and used. Can I
link these two...what I mean is can I input the amount of product I have and
on the other sheet if a part is used have it automatically subtracted from
the inventory, but still allow me to add more quanity?