View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David David is offline
external usenet poster
 
Posts: 1,560
Default produce list automatically from choice of drop down list

I have a drop down column where the choices are say 1 to 100
From the choices listed, I want to create a list automatically from the
results so I can set up if formulas against the choices selected.

Column A Column B
Column C

Choice (drop down box) Automatically adds look
up
selections from column
A formula

using column B
1 to 100 i.e. 90
answers

Is it possible to create a list automatically from the list of answers in
column A?