Validation Tables - how to get one to feed from another

999HelpPlease

New Member
Joined
Jul 16, 2014
Messages
35
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
DogFish
Golden RetrieverBlow Fish
German SheppardGold Fish
Chow ChowAngel 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>
 
Last edited:

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,264
Office Version
  1. 365
Platform
  1. Windows
You're welcome & good luck.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,924
Messages
5,525,656
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top