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
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