produce list automatically from choice of drop down list


D

David

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?
 
Ad

Advertisements

O

Otto Moehrbach

David
Your post was somewhat scrambled. I gather that you have a series of
Data Validation cells in Column A, and you want to make a list somewhere of
the entries selected. If this is correct, simply select all those Column A
cells and Copy, then select one cell where you want to place the new list,
and do PasteSpecial - Values - OK. Done. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top