Hi,
I have a worksheet with data starting at row 2/column C, which I sort based on what's in either column A or column B.

Then I have check-boxes in the data rows that I can move around when doing sort based on column or column B. That works fine and the value of the check boxes are retained even when being moved around due to the sorts.

The problem is that I'd also need to link an appropriate cell to each check box but that link needs to be dynamically updated every time I sort the data.

For example, I have a checkbox in F16 that is linked to cell F16. When I sort the data, the check box would for example move to F11 but it is still linked to F16, whereas I'd like to have it linked to F11 now.

Hope I'm explaining this ok. Does anyone have a solution to this problem? Any hint would be greatly appreciated.

Thanks so much,
Martin