Selection List box in a cell?

P

Paul Corrado

Hutch,

You can accomplish that using Data|Validation|Allow List. The List
reference should be to a Named Range where the user inputs their data. You
should be able to use a dynamic range that would allow for a variable list
length using something similar to the formula below as the Name Definition

=OFFSET($A$1,0,0,COUNTA($A:$A)

To create the named range. (This formula would assume that there is no row
heading and that there would be no other information in the input column,
A.)

Insert|Name|Define

HTH

PC
 
H

hutch

How do I use one sheet to allow the user to enter text in each cell of a
column.
Then in another sheet convert it to a selection list in one cell ?
 

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