inventory Help
 

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.

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/u.../Inventory.xls

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

Regards,
Andrew


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1

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" wrote:


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/u.../Inventory.xls

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

Regards,
Andrew


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1

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

It uses simple Excel functions.

Regards,
Andrew


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1

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

"Andrew L via OfficeKB.com" wrote:


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

It uses simple Excel functions.

Regards,
Andrew


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1