I am taking over a spreadsheet that has a list of options that is specific to
one name in it. Currently when you choose this guy's name, the user has to
hunt and peck for the choices that are specific to him.
Is there a way that I can force Excel to display just those choices when his
name is chosen?