Automatic inventory

[newbiewonkinobie]

I have to make a somewhat simple "automatic" inventory in Excel, but am having trouble getting this accomplished. Basically I have the following:

Date	  Description	In Stock  Shipped  Balance   
8/15/03	   8'Units	  650	   450 	     200	 
8/17/03      4'Units       850      500	      350
8/18/03	   8'Units 	  200	   50	     150

What I need it to do is when the "Description" column is filled out, it will look up the column for any previous items that match (8' units in this example), and put the "balance" into the "In Stock" column. I have looked into Vlookup, match, and a few other things, but I can't get it all together. If you have any solutions, or a better way of doing this, please help.

Flores

 

[bluedragon2]

Here is a suggestion. Instead of running your inventory this way, lets have one area/sheet with just a complete listing of all products/onhand/sold/whatever info about that product you want. Now, you can have an order entry screen that you can put orders into. You can do a vlookup on the product, get the stock onhand, adjust the amount sold, adjust the amount onhand.

Just a suggestion,

Blue