Using Table Column for Data Validation List

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
 
R

Roger Govier

Hi Keith

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

keith

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...
 

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

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Offset Named range in Datavalidation List 4
Data Validation List with blanks 1
SUMIF, use List as a Range 2
Validation From List Not Working 4
Filesize: embedded data validation lists all stored independently? 2
Data validation list using filtered range 3
Can't located named range 3

Top