Thank you. Yeah, there might be few typos as its not the actual spreadsheet. I tried to copy it down from the actual one ( I am restricted to send the actual one). Meanwhile, I have found one of the macro. But I am not able to pass the values correctly on the range of cells to get that work.
Please let me know where am I going wrong. I inserted a new module and trying to call this function from cell using =AddComboBoxToColumns(E1:E57). But here i am doing something wrong in passing values which I am not able to figure it out. Cells Range E1:F57 is where I need a combo box. Can you please correct me?