inventory Help

S

Sdbenn90

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.
 
S

Sdbenn90

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.
 
S

Sdbenn90

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