Validation Tables - how to get one to feed from another

[999HelpPlease]

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 then I go to column B I want to select from a selection of breeds that I have in a different worksheet for the pets. I only want to see the breeds of dogs and not cats or any other pet to come up to keep this selection smaller.

Sheet 1
Column A Column B

Dog

Cat

Bird

Fish Sheet 2 Column A Column B Dog Fish Golden Retriever Blow Fish German Sheppard Gold Fish Chow Chow Angel Fish Maltese Pug Boxer <tbody> </tbody> <tbody> </tbody> In this case when I am in Sheet 1 and in cell b1 I would like a validation list to select from all the dog breeds on my list. Nothing else should appear. Is there a way to do this? I am having no luck finding a solution. I can do a basic validation list but I am unfamiliar with everything else. If you can supply as much detail as possible that would be great.

<tbody>
</tbody>

 

[Fluff]

What you need is dependant data validation, have a look here https://www.contextures.com/xlDataVal02.html

 

[999HelpPlease]

Thank you very much. I will give it a try and see how it works.

 

[Fluff]

You're welcome & good luck.