Hi
I have been asked to create a combo box containing the following information. From a row I need to select the information from, for example A1:X1, and place this in a combo box.
However if a new column is created/inserted the combo box should allow for this and the new value should appear in the combo box list.

Hope that makes sense
Any help on how to do this is much appreciated
New user