Good afternoon,

I have a spreadsheet that has lots of cells with comments inserted and these comments are relevant to the data contained within the cell. When I sort the worksheet the data within the cell moves, however, the comment remains in the cell. I assume that this is due to the comment being linked to the cell rather than the actual data in the cell.

Is there anyway that I can link the comment to the data so that it also moves when the data is sorted?

Thanks

Emyn