Hello. I would appreciate any help with the following problem.

I have a spreadsheet with multiple combo boxes, that is, several logical sections with 200 rows and four-five columns, one-two of which are combo boxes. Our client wants to sort the data in these 200-row sections. I called the Sort routine, and that works fine for plain data columns and combo boxes. The linked cells for the combo boxes are hard-coded, e.g. B120, and those don't change when the data are sorted. Still OK. My problem is that the data in these linked cells are read by other "background" sheets the user doesn't see; the data in these background sheets are formatted to be read into an external program. The problem is that the data on the background sheets is out of whack after a sort on the front sheet.

For example, sorting on plain-text column A, with combo boxes in columns C and D on the input form. Background sheet columns C and D contain the data selected in the combo boxes:

Input Form Background Sheet
A1 B1 C1 D1 A1 B1 C1 D1
A2 B2 C2 D2 A2 B2 C2 D2
A3 B3 C3 D3 A3 B3 C3 D3
A4 B4 C4 D4 A4 B4 C4 D4

After the sort:

Input Form Background Sheet
A4 B4 C4 D4 A4 B4 C1 D1
A1 B1 C1 D1 A1 B1 C2 D2
A2 B2 C2 D2 A2 B2 C3 D3
A3 B3 C3 D3 A3 B3 C4 D4

I know the combo boxes have moved, but I don't have access to where they are physically located. I know what their linked cells are, but that doesn't help me find out which row the combo box is in now.

Thanks in advance for any help you can give.

ElsieC