Hello all !

I would appreciate if you help me.

I want to create a validation data list on the cells of a column depending
the value (in fact is another list) ot the left cell.
Example:
if A1 = Spain then the list of B1 must be the main cities of Spain
if A1 = UK then the list of B1 must be the main cities of UK
etc

where A1 is the selection from the list of countries of Euope ...

Thanks a lot, Gemma.

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


On Oct 22, 3:30*pm, GAMN wrote:
Hello all !

I would appreciate if you help me.

I want to create a validation data list on the cells of a column depending
the value (in fact is another list) ot the left cell.
Example:
if A1 = Spain then the list of B1 must be the main cities of Spain
if A1 = UK then the list of B1 must be the main cities of UK
etc

where A1 is the selection from the list of countries of Euope ...

Thanks a lot, Gemma.

Hi

Take a look at a tutorial (with sample download) I have written at
http://www.contextures.com/xlDataVal15.html

--
Regards
Roger Govier

"GAMN" wrote in message
...
Hello all !

I would appreciate if you help me.

I want to create a validation data list on the cells of a column depending
the value (in fact is another list) ot the left cell.
Example:
if A1 = Spain then the list of B1 must be the main cities of Spain
if A1 = UK then the list of B1 must be the main cities of UK
etc

where A1 is the selection from the list of countries of Euope ...

Thanks a lot, Gemma.

__________ Information from ESET Smart Security, version of virus
signature database 4532 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4532 (20091022) __________

The message was checked by ESET Smart Security.

http://www.eset.com

On Thursday, October 22, 2009 12:30:01 PM UTC+2, GAMN wrote:
Hello all !

I would appreciate if you help me.

I want to create a validation data list on the cells of a column depending
the value (in fact is another list) ot the left cell.
Example:
if A1 = Spain then the list of B1 must be the main cities of Spain
if A1 = UK then the list of B1 must be the main cities of UK
etc

where A1 is the selection from the list of countries of Euope ...

Thanks a lot, Gemma.

Hello, am unable to open the link. It is giving me the following message

Oops! Google Chrome could not connect to www.contextures.com

Try reloading: www.*contextures.*com/*xlDataVal15.*html