Excel Data Validation - List

[Md1]

Hi all

A good while ago I found a way to use data validation to achieve the following

I have 2 columns of data - I want to be able to use data validation on the first column to select its contents......then based on the results of the first column contents, use data validation on the second column......however there is a way to have the selection choices of the second coloum change depending on the results of the first column.

I'm sure this makes little sense but assume the following

Column A contains data validation list of countries
Column B contains Capital Cities of countries

I'm sure I have seen a way to select for example France in column A and then the only choice for column B would be 'Paris'

I think it may have used Index but its been a while.

Is anyone familiar with this?

regards

Md1

 

[erik.van.geit]

Hi,
take a look at this "famous" thread
(the link is already pointed to the "most relevant post")

http://www.mrexcel.com/board2/viewt...=0&postorder=asc&highlight=cascading&start=26

for a technique using comboboxes
http://www.mrexcel.com/board2/viewtopic.php?t=152281&start=5

see also this explanation
http://www.contextures.com/xlDataVal02.html

and
http://www.mrexcel.com/board2/viewtopic.php?t=15030&highlight=
feel free to send an email (no PM)
you'll get three files with examples

subject of email
cascading comboboxes

kind regards,
Erik

 

[Md1]

Splendid - thanks very much.

 

[erik.van.geit]

you're welcome
feel free to email for samples