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?
|