Multiple dropdown based on cell value.

[mohanprabhus]

I'm trying to write a macro that with Dependent Multiple dropdown based on Column cell respectively and below mentioned fixed content in sheet2 & in Sheet1 i need the data based on cell value for till nrows.
Sample data mentioned below

Mname	mvalue	mtext	mid	mextn
abc	1	xyz	q1	po1
abc	2	wer	q2	po2
dbc	1	gdf	k2	po1
dbc	5	jyty	q1	po4
acd	10	xyz	k2	po5
acd	1	wer	k2	po10

I need the result in Sheet1 N rows with dropdown and column1,column2,column3,column4,column5 (with dropdown) & also when first field is empty or i change the value in column1 rest all the column values to be empty.

 

[mohanprabhus]

Hi team,

Can anyone help me on this issue.