PDA

View Full Version : Solved: Data Validation list based on a filtered list.



khalid79m
11-17-2009, 05:26 AM
I have table named "Table" a range named within that table as "Test",

I have cell on another sheet with validation list linked validation is =test

so when I filter on my table , the validation list should only show me test but the filtered results only, not the enitre range.

can anyone help, i hope the above makes sense

geekgirlau
11-17-2009, 10:29 PM
Can you post an example? A cut-down version of your data would be great, as well as the end result you are expecting.

khalid79m
11-20-2009, 03:06 AM
sorry this is no longer required :)