Thread: Drop Down List
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Victoria_Wells[_2_] Victoria_Wells[_2_] is offline
external usenet poster
 
Posts: 3
Default Drop Down List

Hi there

I am really struggling with a list. Basically, I have 3 colums, Product,
Unit & Price.
I want to create a drop down list which allows me to select multiple rows
for a quote, but pulls in all 3 columns, therefore giving me the product
name, the unit it is sold in and the cost per unit, without me having to type
it in everytime. It absoloutely needs to have all 3 columns included, it is
not an option to put everything into 1 column. Is this possible?