Selection List box in a cell?

  • Thread starter Thread starter Paul Corrado
  • Start date Start date
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
 
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 ?
 
Back
Top