Prevent mismatched columns following sort operation
 

Greetings,

I have a spreadsheet with 5 columns including two hidden columns. Each
row is identified by an ID, which is one of the hidden columns. End
users will be modfying data in one of the columns. I need to make sure
that the column the users modify will never become disconnected from
its ID. I could protect the columns, but that places several
restrictions on the end user (you can't sort Protected cells).

Are there other options? For example, I could add a note containing
the ID to each cell in the column the user can modify? Could the note
be made invisible or protected?

Thanks in advance,
MattH