how do I

senario : i have three costs, three catagories, three codes

if i select code (a) it needs to auto collect pertaining data and sho
them in pre selected cells, which in this case would be
(A), product text, Cost (digits) there will only be three combination
and the data will not vary from these combinations. when i select (a
the relevant product data will be displayed , along with the cost

if code is needed and is available it would be much appriciated

reg

--
kevat
-----------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...fo&userid=3024
View this thread: http://www.excelforum.com/showthread.php?threadid=51235