Keep cell data with records from a query

G

Guest

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?
 
G

Guest

Hello,
That looks like a possible solution but my problem is a little different (I
think). I currently have one sheet that I use to run my query. I have a
another sheet that I use to copy over from the query sheet. I have an
additional column on sheet 2 that I use to enter my comments. How would that
solution work for my situation?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I expand formula down a column when query results change? 4
Excel Help to copy information from one row at a time to another sheet 1
Retaining additional row info on refreshing data table 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
My Excel file is not calculating! 13
Cell/Range references and Microsift Query 2
Wait statement in macro 1
2007 Excel Pivot Tables - Error Message too many records? Help 1

Top