I currently have one validation list.
Lets say it is different types of pets (dog, cat, bird, fish, etc) and that is in column A on Sheet 1. This is my current validation list and there are 15 different options to select from currently.
What I need to happen is if I select dog in column A and...