ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keeping cell data with records from a query (https://www.excelbanter.com/excel-discussion-misc-queries/127313-keeping-cell-data-records-query.html)

Secret Squirrel

Keeping cell data with records from a query
 
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?


All times are GMT +1. The time now is 04:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com