Validation based on a range of values

You can define a range with a "dynamic range" i.e a range which adjusts itself automatically ...

Insert Name Define
give your range a name
in the formula area type
=Offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),CountA(Sheet1!$1:$1))

HTH
Carim

Originally Posted by Carim

You can define a range with a "dynamic range" i.e a range which adjusts itself automatically ...

Insert Name Define
give your range a name
in the formula area type
=Offset(Sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),CountA(Sheet1!$1:$1))

HTH
Carim

that is to say that the list starts in A1.
If the list of names is 1 column, the CountA(Sheet1!$1:$1) is replaced with 1

avner

Thanks guys. I got it. That works great!

Glad your problem is fixed

Thanks for the feedback

Carim