Returning a qualified drop down list
Thanks Sébastien! Works great!
"sebastienm" wrote:
Hi,
Check "Dependent Dropdowns from a Sorted List" at
<http://contextures.com/xlDataVal13.html
--
Regards,
Sébastien
<http://www.ondemandanalysis.com
"rlmeyers" wrote:
If my data is something like this;
A B C
Sharp ND-208U2 208 W
Sharp ND-216U2 216 W
GE GEPVp-066-G 66 W
GE GEPVc-170-MS 170 W
GE GEPVp-185-MC 185 W
GE GEPVp-200-MS 200 W
Sanyo HIP-180B2-BO-01 180 W
Sanyo HIP-190B2-BO-01 190 W
Sanyo HIP-180BA3 180 W
From the data above, I want to be able to select from a drop down list
either "Sharp", "GE", or "Sanyo". In the next cell, I want the drop down
list to only return those lines that are "Sharp", "GE", or "Sanyo", then I
want to perform lookups deeper within those lines.
Can anyone help? Please be as detailed as possible, as I am not a big macro
user...
Thanks!
|