Simple Formula Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
The simplest inventory control sheet resembles a checkbook. In C1 put the
initial inventory for a part. Starting in A2 and on down put the withdrawls.
Starting in B2 and on down put the deposits. Then in C2 put =C1+B2-A2 and
copy down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add/Subtract columns from tab to tab in same file 3
Divide One Amount for Duplicates 1
Formatting issue 0
How do I update information bewteen two spreadsheets? 5
I want to add or subtract a range of cells 2
stock inventory 1
Inventory Update Form 3
Access Scan a UPC on a txtfield on mainform & add to subform Please Help! 1

Back
Top