I have a qry which calls data from a SQL db and inserts it into an XLS
spreadsheet. However, once the data has been called, I manually enter a
supporting numeric code to the same sheet. The manually-entered code needs to
remain with the record I add it to.
However, when I refresh the data, the data shifts on the XLS sheet, and a
record is no longer on the same row as the code I manually entered.
I was thinking there may be a way to have the qry only insert new records,
and add them at the bottom of the spreadsheet so it doesn't re-sort (I don't
have any sort options set), but I don't know how to do that (or if it can be
done)?
Can someone help with this, or suggest a better solution?

Thanks!