I attached a spreadsheet with some sample data representative of my problem. The first tab represents the main data tab. The "Breed" column contains data that will be periodically updated from an external source. Each "Breed" has a corresponding "Animal" value. The Animals are then separated into their own distinct sheets. In the spreadsheet you see this represented with the sheets labeled "Dog" and "Bird". In the "Dog" and "Bird" sheets, I would like the breed list updated with the corresponding breeds from the first tab automatically. Is there a way to do this without writing a VBA macro? Thanks for the help!
Bookmarks