Dropdown list selection data range value update

[Parth007]

Hello Friends,

How can one make the values change on the change of dropdown value?

Like in attached sheet

If user select Chair then next to it all values in Range assigned should be populated
if Table selected then its value & if glass then its value?


Can this be done with any formula or function or any other approach?

[JOHN H. DAVIS]

Try the attached to see if it does what you want.

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[YasserKhalil]

To test the most rows.count of any of the ranges try this modification

Please Login or Register  to view this content.

[Parth007]

Grt Excel Forum.. got wayout from here itself..

Thanks John & yaseer.. its done

[YasserKhalil]

You're welcome
thanks for the feedback and for the rep points
Regards

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.