Using Table Column for Data Validation List

  • Thread starter Thread starter keith
  • Start date Start date
K

keith

Hi,
In Excel 2007... Is there any way I can use a column in a Named Table as
my data validation list without specifying the range. For example I have a
table named MyTest of ID/Name. I want to display the Name column as my data
validation list. Any time I try using my source as =MyTest[Id] in the
DataValidation List Source I get an error. I want to find a way to do this
without specifying the given range within my table because my tables might
use different start range cells.

Thanks,
Keith
 
Hi Keith

In Name Manager create a new name called myList with a reference of
=MyTest[Id]
In DV, use List, Source myList
 
That works great. Thanks.

Keith

Roger Govier said:
Hi Keith

In Name Manager create a new name called myList with a reference of
=MyTest[Id]
In DV, use List, Source myList
--
Regards
Roger Govier

keith said:
Hi,
In Excel 2007... Is there any way I can use a column in a Named Table as
my data validation list without specifying the range. For example I have a
table named MyTest of ID/Name. I want to display the Name column as my
data
validation list. Any time I try using my source as =MyTest[Id] in the
DataValidation List Source I get an error. I want to find a way to do this
without specifying the given range within my table because my tables might
use different start range cells.

Thanks,
Keith
Click to expand...
Click to expand...
 
Back
Top