inventory Help

[Guest]

Trying to set up Inventory control. I need 2 sheets, 1 Being the Master
Inventory List(with designated starting #'s) and the other tracking
transaction of inventory being pulled. I also would like the transaction
sheet to update the master Sheet as it is pulled. Any help doing this would
be greatly appreciated.

 

[Andrew L via OfficeKB.com]

I'm not sure if this is what you are looking for, or not, but I've uploaded
an example at the following URL. I hope it helps get you started.

http://nws.emersonnetworkpower.com/uploads/uploads/Inventory.xls

The file will remain on the server for 10 days and then be automatically
deleted.

Regards,
Andrew

 

[Guest]

That was very helpful, Thank You. This more of what I need help with

Sheet 1 (Pulled)
Date P.O. # Customer Description Need Pulled Inventory
8/1/05 12 ABC CO. B100 5 5
# Left

Sheet 2 (Master)

Description OH
B100 25 <----This should reflect 20 because 5 were taken from
invent.

As each Transaction is is entered I need Sheet 1 to find the same Desc. on
Sheet 2 and updatethat Item. The inventory on sheet 1 should reflect the new
updated inventory from Sheet 2. Hope this is a little mote clear sorry for
any confusion and again your help is greatly appreciated.

 

[Andrew L via OfficeKB.com]

Try this: http://nws.emersonnetworkpower.com/uploads/uploads/Inventory2.xls

It uses simple Excel functions.

Regards,
Andrew

 

[Guest]

That is exactly what I needed. Thank you so much for your assistance.
Thank You.