Hi,
Is there a way to make Excel display filtered list based on Data Validation range? For example:
Sheet1:
Column A Column B (data validation set to List (Sheet2!$B$1:$B$100)
store1
store2
store3
Sheet2 (contains a list for Data Validation of column B on Sheet1):
Column A Column B
store1 product1
store1 product2
store1 product3
store2 product4
store3 product5
store3 product6
So, when I have "store1" in Sheet1:A1, I need Excel to filter the Validation List based on this value and display only "product1", "product2", and "product3" in the dropdown list for cell Sheet1:B1. Is it doable?
Also posted here
Is there a way to make Excel display filtered list based on Data Validation range? For example:
Sheet1:
Column A Column B (data validation set to List (Sheet2!$B$1:$B$100)
store1
store2
store3
Sheet2 (contains a list for Data Validation of column B on Sheet1):
Column A Column B
store1 product1
store1 product2
store1 product3
store2 product4
store3 product5
store3 product6
So, when I have "store1" in Sheet1:A1, I need Excel to filter the Validation List based on this value and display only "product1", "product2", and "product3" in the dropdown list for cell Sheet1:B1. Is it doable?
Also posted here