Dynamic Validation List

users
#1

Hi All,

Based on: http://www.contextures.com/xlDataVal02.html#Dynamic

I'm wondering if there is an easier way to do a dynamic validation list
than that relatively complex method in that post pertaining to Excel. I
swear I've done it before but for the life of me I can't remember how.

Setup:

Sheet: "Information"
A>B
Dog>18lbs
Dog>20lbs
Dog>22lbs
Cat>5lbs
Cat>10lbs
Cat>15lbs

Sheet: "Summary"
A1: Dropdown that has Dog/Cat

*need* A2: To list the related list based on whether A1 is Dog or Cat.

Thanks in advance.

Best,
Joel

#2

Hi Joel,

find attached a sample file, I hope it is what you want.
To avoid duplicates in the list it`s needed to mark 'Sort entries ascending'
Be aware of Menu/Tools/Options/LibreOffice calc/General - Expand formatting,
if it is activated, when selecting in A1, then A1 DataValidaty overwrite
DataValidity in cell to the right, perhaps a bug.

Regards.
Miguel Ángel.

DataValidation_SelectiingMatchingRows.ods
<http://nabble.documentfoundation.org/file/n4175964/DataValidation_SelectiingMatchingRows.ods>

#3

Hi Miguel,

Hi Joel,

find attached a sample file, I hope it is what you want.
To avoid duplicates in the list it`s needed to mark 'Sort entries ascending'
Be aware of Menu/Tools/Options/LibreOffice calc/General - Expand formatting,
if it is activated, when selecting in A1, then A1 DataValidaty overwrite
DataValidity in cell to the right, perhaps a bug.

Thanks so much for taking the time to play around with this and give me
a sample. I'll check it out and see how I can put it in my sheet. Thanks
again!

Best,
Joel