If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running totals in excel
Good afternoon all. I need a little assistance with using spreadsheets to keep an inventory updated. I have 7 column headings each referring to a different type of equipment. I have another column for a date, one representing whether the the equipment was shipped or received and finally which facility was receiving or shipping the product. So in each row I would enter a date, how many pieces of equipment was either shipped or received and then the shipping / receiving facility. My questions are, how would I keep a running total of a particular facilities current inventory with so many shipments and deliveries? Secondly, would it be easier to make a different worksheet for each facility? And keep track that way? This is the first time using this forum so any help would be greatly appreciated. -- chuck2 ------------------------------------------------------------------------ chuck2's Profile: http://www.excelforum.com/member.php...o&userid=29642 View this thread: http://www.excelforum.com/showthread...hreadid=493546 |
#2
|
|||
|
|||
Running totals in excel
This is not the type of problem Excel is very well suited for.
But it can be done; check: http://www.mcgimpsey.com/excel/accumulator.html -- Kind regards, Niek Otten "chuck2" wrote in message ... Good afternoon all. I need a little assistance with using spreadsheets to keep an inventory updated. I have 7 column headings each referring to a different type of equipment. I have another column for a date, one representing whether the the equipment was shipped or received and finally which facility was receiving or shipping the product. So in each row I would enter a date, how many pieces of equipment was either shipped or received and then the shipping / receiving facility. My questions are, how would I keep a running total of a particular facilities current inventory with so many shipments and deliveries? Secondly, would it be easier to make a different worksheet for each facility? And keep track that way? This is the first time using this forum so any help would be greatly appreciated. -- chuck2 ------------------------------------------------------------------------ chuck2's Profile: http://www.excelforum.com/member.php...o&userid=29642 View this thread: http://www.excelforum.com/showthread...hreadid=493546 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
suggestion for excel tool option | David Coleman | General Discussions | 7 | November 10th, 2005 03:33 AM |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | MEGTOM | New Users | 5 | October 27th, 2005 03:06 AM |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |
Running Excel vba within IE | Dave Peterson | Setting up and Configuration | 10 | March 25th, 2004 01:38 PM |