Ron, you are a genius! That works almost perfectly ...only hiccup i have
found is if a stock number is entered on line 200 and i try to enter the
same # on line 210, it works...but if i enter it anywhere above that
...like line 150 it does not work!? any way of getting around that??


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=481999