Dear All,
Hope this post finds u in good health.
I have one query w.r.t. enhanced drop down selection in excel (File attached)
for e.g. i have product A which has two class x and y; x has two variant l and m
so is it possible that if i select product A in drop down (cell G2) only class x and y is visible in drop down cell G4 and further if i select x it will show variants l and m only in the drop down cell G6.
The same logic for all the product (B & C) and sub variants (z, p,q, r).
hope i was able to communicate the problem properly.
Bilboy
Hope this post finds u in good health.
I have one query w.r.t. enhanced drop down selection in excel (File attached)
for e.g. i have product A which has two class x and y; x has two variant l and m
so is it possible that if i select product A in drop down (cell G2) only class x and y is visible in drop down cell G4 and further if i select x it will show variants l and m only in the drop down cell G6.
The same logic for all the product (B & C) and sub variants (z, p,q, r).
hope i was able to communicate the problem properly.
Bilboy