I have a worksheet that I use to compile data from a query through an ODBC
connection to my access database. Columns A thru G are populated from the
query and then I use column H to enter any notes for a specific record.
Column H does not come from the query, it's just used within the worksheet.
Is there a way to keep those notes with that particular row of data even
after the query is refreshed and that row is moved down the list? Right now
if I enter data on a row and then refresh the query it may move that row down
some but the notes that I entered stays on the row I originally entered them
on. Is this possible?