I have a spreadsheet with a table of data which has been imported from an
Access Database. If new records have been added on the database, then when I
refresh the data in Excel it will add these new lines onto the spreadsheet.
I need to be able to put certain comments in my spreadsheet against lines of
data from the database. However, if new lines are inserted when I refresh
the data, the comments can end up being next to the wrong record.
Is there any way to keep my lines of comments attached to a particular
record of external data, so they will move when the record does?