Can you do this with a list???
 

Hi, is it possible that you can have a drop down list that displays
rows of information like this

a1 b1 c1
Name QTY Code
Peach PC
Apple AP
Pear PE

and enables the user to select the right code and enter the quantity in
one cell..like this

a2
10PC


thanks