This is the second part to a problem Ive descussed in a previous thread
(thanks Karen). I have 2 rows one with part numbers in and one with the
total amount of those parts in stores. Two separate cells have been
dedicated one to enter a requested part number and the other to enter
the amount taken out of stores. As it stands this works, but the
problem I have is when the amount in the request box is cleared the
total goes back up to its original which is no good. Is there a way I
can prevent the total from going back up to its original so that every
time i remove a part the total goes down, and just one final question,
can I put some kind of low level warning when the quantities are down
to a set amount?? many thanks for any help.


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