Hi,

I've been scratching my head about this for days.

I have an excel spreadsheet which is linked to an Sql table and so the contents of the Sql table changes the excel spreadsheet is updated.

What I want to do is add a column only in excel with comments about the row. However obviously as this column is not part of the Sql import when Sql updates the spreadsheet all of the Sql rows move but the comments don't.

Is there a way in which I can link the row in the added description column to a value in one of the excel columns so that the entire row moves together??

Thanks