Combo Box help

[i4c4p4]

Hello,

I created a spreadsheet with several combo boxes that that is linked to other data.

When this data is sorted, the values in the combo boxes are automatically changed.

Is there any way to prevent the the values to change?

Thank you.

[Special-K]

How about copying the data to a separate range and sorting the range. Your combo box will still be pointing at the original data.

e.g

Column A1:A10 Data
Combo box points to A1:A10

Macro to copy data to column B
Sort column B

[i4c4p4]

This will not work, the data in the data range is changed on an hourly basis and my boss will not want to maintain 2 lists.

Any other ideas.