Hi

I am trying to set up lists with sub lists using data validation. In
column A you will choose from a list, the options to choose from in
column B will be dependant on the choice in column A. Each option in
column A has an associated named range with the 'sub options'.

When using a static named range I was able to use the the following
formula as data validation =indirect(A1). However when I convereted
the named range to a dynamic range the data validation produced an
error.

Help!


--
Mark_Robinson
------------------------------------------------------------------------
Mark_Robinson's Profile: http://www.excelforum.com/member.php...o&userid=33127
View this thread: http://www.excelforum.com/showthread...hreadid=529407

There are instructions here for using dynamic lists:

http://www.contextures.com/xlDataVal02.html#Dynamic

Mark_Robinson wrote:
Hi

I am trying to set up lists with sub lists using data validation. In
column A you will choose from a list, the options to choose from in
column B will be dependant on the choice in column A. Each option in
column A has an associated named range with the 'sub options'.

When using a static named range I was able to use the the following
formula as data validation =indirect(A1). However when I convereted
the named range to a dynamic range the data validation produced an
error.

Help!




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thanks - Very helpful

Mark


--
Mark_Robinson
------------------------------------------------------------------------
Mark_Robinson's Profile: http://www.excelforum.com/member.php...o&userid=33127
View this thread: http://www.excelforum.com/showthread...hreadid=529407