All Data bind from Database dynamically , we can not count the value of lists.
A column in worksheet1 having a list
after select value in list A, Column B will be bind
But in column B Dropdown List having Blank values(remove the blank value)
Column A bind from worksheet 2,
Column B Dropdown list bind from worksheet 3 according to column A selection. but contains blanks value
What I have tried:
I use OFFSET , resize column , etc but didn't get success.