I did the enhancement, but its causing a problem as below:
For all the data validated cells the dropwodn is working, but only and only for one column with the data validation is not working.
Let me explain:
I have a column C(in which all most all the cells are implemented with the data validation). well i am taking its screen shot. please find it.
With data validation the values are being shown.
Its not showing any values particularly for those cells in the drop down- for which i wrote code.
Its showing the values for the datavalidated cells only.
Also there is a formula which i have pasted..
In the screenshot check it out, i have made the dropdon little small so that you people can distinguish the values not coming in to the dropdown.