I have several files that I use to track inventory.  Each file is one product.  In each file I have a running total of the inventory on hand.  This only takes 2 cells per file.  Question:  How can I send my running total from each file to another so I can see my inventory without opening each file seperately? Any help would be greatly appreciated.  BTW I am just learning the basics of Excel.

---

Richard Adds...

First, I would suggest you switch over to a database program like Microsoft Access which is MUCH better at tracking inventory.

However, if you want to use Excel then just put each item in a separate sheet. I would recommend keeping your running total in a NAMED CELL. Then you can refer to all of your different named cells on a summary sheet.

=Sheet1!PartATotal
=Sheet2!PartBTotal
etc.

Or you could keep ALL of your parts in the SAME SHEET and just specify part numbers in one of your columns. Then you could use the SUMIF() function to add up the total inventory for each specific part.

There are several ways to do it, but again I would generally recommend a DATABASE for this task, unless your inventory needs are VERY simple.