hi all,
is it possible to generate a drop down list in one cell,
when you have chosen something from a drop down list in another cell.
example:- i have a drop down list containing all 20 premiership football clubs.
If i choose, Arsenal for instance, can i set it up so that in another cell a drop down list is generated containing 'Arsenal's' squad members, and the same to happen for whichever team i select in the first drop down list, showing thier squad in the second drop down list.
hope this can be understood.
cheers, boufant
Bookmarks