Im Trying To Write A Simple Sheet That Basicly Lists All The Components
In Stock With There Quantities, And Then Have A Cell Dedicated To
Selecting A Component And Entering A Quantity That Has Been Removed
From The Total Individual Amount.i.e

B1=(item)msc213 C1=(qty)23
G1=(item Selector, Select Say)msc213 H1=(qty Removed From Stores)2
That Would Then Subtract The Amount From The Right Cell 2-23=21.

As Im A Beginnner Any Help With The Formula Would Be Great!!!
Many Thanks


--
alanled
------------------------------------------------------------------------
alanled's Profile: http://www.excelforum.com/member.php...o&userid=30949
View this thread: http://www.excelforum.com/showthread...hreadid=510993