Hey guys, here's an easy one (for the likes of you, not me).
I want to create a drop down list in B3 based on the choice made from another list in A3.
In the Example document attached, I want A3 of "Matrix" to have a drop down list of all options in Col A of "Positions", I then need B3 of "Matrix" to have a drop down list of the options available from the choice in A3 based on the list in Column B of "Positions".
Ie. A3 Choice is "Government Representative", means the drop down list in B3 is restricted to the options next to Government Representative in "Positions".
I hope that makes sense.
Cheers
FF
Bookmarks