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 show them in pre selected cells, which in this case would be
(A), product text, Cost (digits) there will only be three combinations 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

regs