M
Mark_Robinson
Hi
I am trying to set up lists with sub lists using data validation. I
column A you will choose from a list, the options to choose from i
column B will be dependant on the choice in column A. Each option i
column A has an associated named range with the 'sub options'.
When using a static named range I was able to use the the followin
formula as data validation =indirect(A1). However when I converete
the named range to a dynamic range the data validation produced a
error.
Help
I am trying to set up lists with sub lists using data validation. I
column A you will choose from a list, the options to choose from i
column B will be dependant on the choice in column A. Each option i
column A has an associated named range with the 'sub options'.
When using a static named range I was able to use the the followin
formula as data validation =indirect(A1). However when I converete
the named range to a dynamic range the data validation produced a
error.
Help