I have a list in column A. This list can have 5 entries in it (using data validation). Depending on what I select in column A I want to only show the subordinates to that 'topic" in a drop down list in column B.
Please see file attached.
how do I set up column b to only show the subordinates of the respectve topic in column A?
Very frustrated!!
Thanks
Bookmarks