I want to create synchronised validated lists in Excel so that, when I choose
one item from the first list, I can only choose from a set items in the
second list. If I choose a different item in the first list, I will only be
able to choose from a different set of items in the second list. Is there a
way to do this? I am using Excel 2007, with Windows XP.