User selects a value from dropdown list and the dependent values gets autopopulated

Hello,

If user selects a value from the drop down list, then the dependent values which are available for the selected value should get autopopulated in the collumn.

There are two values in the drop down list that i created - IM and CM. Please find the dependent values for IM and CM below. I have placed the dropdown list in collumn A. If user select the value IM OR CM from any row in column A, I want the dependent values to be autopopulated in the corresponding collumn B as a list. User can select the values IM or CM from any row in the collumn A and the dependent value should get populated. I would appreciate and It would be really helpful if you could help me with the code for this

Value Dependent Value
IM In #
IM Business
IM Company
IM Priority
IM ID
IM AF


Value Dependent Value
CM RC
CM LOB
CM Company
CM CT


Regards,
San

Hi. Is this what you had in mind?

Here is one interpretation of what your requirements could be. If IM is choses then the values for IM are listed under. If the values for CM is chosen then that listing is presented.

Is this what you mean?

The way I read it was that the OP wanted to have the freedom to start his list from ANY cell in column A. If that's the case, I suspect it's a VBA solution that's needed.

"If user select the value IM OR CM from any row in column A"

@Glenn

You are probably right unfortunately. I just wish that proper examples were given when questions were posed. I'm getting tired of "guessing games".

If I was a betting man, I bet that all the choices are wanted in a single cell too because even with VBA, the cells in column B would be pushing the next available row down and eliminating all the neighbouring cells in column A.

This is a way to use each row horizontally.

If all the choices were wanted in one cell, isn't that simple?

To whichh of us were you referring when you said "your"?