Data validation: concatenate two separate ranges in the List?

[DaveO]

In setting up data validation to allow a cell entry from a specified
list, you can define a named range to represent the list and enter the
reference =NamedRange. Is it possible to concatenate two distinct
ranges into a single list?

 

[Anne Troy]

Not to my knowledge, at least not easily. In the past, I have concatenated
the data in an additional column on my data sheet...even if I then hide that
column from view.

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

 

[DaveO]

...at least not easily

I was able to write some code to append list1 to the bottom of list2,
and expand the .RefersTo range of list2 to accommodate.

Thanks for your response!

 

[Debra Dalgleish]

There's a sample file here with combined lists:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0014 - Combine Multiple Lists into One'