I am using drop down lists with Excel to list the contents of cells A3 to A30.
The contents of these cells are not in aphetical order, therefore are shown within the drop down list in the same, none alphabetical order.
I know that one solution to getting it in aphetical order is to simply re-arrange the date in cells A3 to A30. However, I have a few macro's running in the background of this and also some naming structures which would need altering also. As I am going to be expanding this selection, from A3 to A30 to A31 then A32 etc.
I wondered if there was some VB code which would automatically order the drop down list in aphetical order? if so, please will you help me?