I have a bit of a problem! Just supposing I have 3 fields in columns A, B and C named Item, Quantity and Price, I want to know how to get all of this data to appear in a combo box. Does anybody know how to do this?

Then, if one record was selected from the combo box, I want this record to be placed somewhere else on the spreadsheet e.g. to the right of the combo box. Is there an easy way of doing this?

Any help would be much appreciated!

James