Creating a Data Validated dropdown is a straightforward task, however every now and again the question comes up of "How do I make the contents of a second dropdown change depending upon the choice made in the first drop down"
As there are embedded screenshots in my 'How to' notes I am attaching an MS Word file which has full instruction on how to do it.
Hope it helps someone.
Patrick
