S
Simon Skelton
Hi
Has anyone else experienced this issue or I am doing something wrong.
I have a series of dynamic range names defined using offset. For example
the name USCities is defined as =offset(AA1,0,0,Counta(AA:AA),1) and the name
Europeancities is defined as =offset(AB1,0,0,counta(AB:AB),1)
In column A, dataentry into the cells is limited to USCities or
Europeancities.
In column B, I want to limit data entry to the range name appearing in
column A.
For example if USCities is selected in A1, data entry in cell B1 is to be
limited to those cells forming the USCities range name.
I have tried to do this using the list option in data validation using the
formula in column b = indirect(A1) etc.
However, when I do this Excel 2003 generates an error during the data
validation process.
Interestingly, no error is generated where the named range is static ie
AA1:AA12 rather than dynamic.
Any solutions to this problem or work arounds would be gratfully appreciated.
Cheers - Simon Skelton
Has anyone else experienced this issue or I am doing something wrong.
I have a series of dynamic range names defined using offset. For example
the name USCities is defined as =offset(AA1,0,0,Counta(AA:AA),1) and the name
Europeancities is defined as =offset(AB1,0,0,counta(AB:AB),1)
In column A, dataentry into the cells is limited to USCities or
Europeancities.
In column B, I want to limit data entry to the range name appearing in
column A.
For example if USCities is selected in A1, data entry in cell B1 is to be
limited to those cells forming the USCities range name.
I have tried to do this using the list option in data validation using the
formula in column b = indirect(A1) etc.
However, when I do this Excel 2003 generates an error during the data
validation process.
Interestingly, no error is generated where the named range is static ie
AA1:AA12 rather than dynamic.
Any solutions to this problem or work arounds would be gratfully appreciated.
Cheers - Simon Skelton