C
Ciarán
I'm trying to populate 2 cells using pre-defined lists and force the
second cell to be dependent on the contents of the first.
The example below illustrates what I'm trying to achieve.
Using a table like this:
ColumnA ColumnB
Ciaran Football
Ciaran Basketball
James Running
James Swimming
In CellA2, I want to use data validation to give the user the option
to choose either Ciaran or James. Oh, I also need this selection to be
unique - I don't want Ciaran or James to appear twice.
Then in CellB2 I want to use data validation to give the users the
option to choose from ColumnB, restricted to those options which make
sense.
So if the user selects Ciaran in CellA2, they should only be offered
the choice of Football or Basketball in CellB2.
second cell to be dependent on the contents of the first.
The example below illustrates what I'm trying to achieve.
Using a table like this:
ColumnA ColumnB
Ciaran Football
Ciaran Basketball
James Running
James Swimming
In CellA2, I want to use data validation to give the user the option
to choose either Ciaran or James. Oh, I also need this selection to be
unique - I don't want Ciaran or James to appear twice.
Then in CellB2 I want to use data validation to give the users the
option to choose from ColumnB, restricted to those options which make
sense.
So if the user selects Ciaran in CellA2, they should only be offered
the choice of Football or Basketball in CellB2.