Dynamic drop down in excel , without blank value in list

Hi Chill60 ,

Thanks for your support,

I am binding drop-down from C# Code, Drop-down values will be dynamic.

Drop-down B list items will be populated based on Drop-down List A item selections.

so My problem is this , if column B allocate for drop down B binding, so we don't know the values of drop-down B because its bind from Database, So that If values are more then table selection(Table for column B) then that values got missed, and if values are less then table selection for drop-down B, then drop down B filled by list values and blank spaces.

hi chill60,

Actually my problem is this,all data comes from DB in worksheet 1 and worksheet 2,
in worksheet 3 we have 2 drop downs ,
User can select 1st drop down then 2nd drop down will be bind based upon 1st drop down selection,

worksheet 1:
A B
DOM Domestic
BEHV Behaviour

Worksheet 2:
A B
DOM BEHV
DOM1 BEHV1
DOM2 BEHV2
DOM3 BEHV3
DOM4 BEHV4


Here is DOM and BEHV in worksheet 2 is column name and dom1 ,dom2,dom3,dom4,behv1,behv2,behv3,behv4 comes from DB.

In Worksheet 3 , user select in 1st dropdown DOM then dom1,dom2,dom3 dom4 will be the element of Drop down 2 , if user select behaviour(BEHV), then 2nd drop down element will be behv1,behv2,behv3, behv4,


Now come to the problem: element in worksheet 2 will be max up to 100 then dropdown 2 will miss the element , if we select table range 100 , and element can be 120 (then 20 element will be missed), if element is 80 then (blanks will be added in second drop down).

We need to show exact element it could be 70 , 80 150, 120.

Please help: if you unable to get the problem , whatsapp me any time, please help me its urgent issue , getting too delay.

Thanks in advance