I have 3 columns: A B and C

Column C is a range named list that is used in a combo box

Column B has a list of data from B1:B12

In column A, a person would put the letter "x" when they wanted th
data from column B to be in the combo box (in other words, column C).

My question is, is there a code I can use to put the data in order i
column C? For instance, if cells A3 and A7 had checks in them, th
data in cells B3 and B7 would show up in cells C1 and C2 respectively.
Then, if the "x" was deleted from A3, B7 would then be in cell C1.

Any help would be appreciated

--
Message posted from http://www.ExcelForum.com