I have a spreadsheet which pulls data from a database (I cannot manipulate the database itself).
I added a column (column A "Status") to the worksheet where I manually input a status for each row/record - this is for my own records and I don't want this information on the main database.
When I refresh the data or sort the data, column A remains static, meaning that the information in column A no longer relates to the correct rows/records. (No frozen panes etc.)
I tried inserting a new column into the spreadsheet at column B, instead of column A (so my Status column is inside the data, not next to it). Now, when I sort by any column, the new status column sorts together with it. But when I refresh the data, I have the same problem as before.
How can I add a column to the spreadsheet so that the information I enter into it remains associated with the rows/records of the refreshed data?