Linking manual entry data to query data so it all shifts together.

J

jessica

I'm using ODBC to import data into an Excel spreadsheet. Part of the spreadsheet is made up of the imported data and the other part is made up of manual entry data. Each time I refresh the query data, new rows are added into the query

Now here's the problem

Each time a new row of data is added in the query, it shifts the data only in the query range. The manual entry cells stay the same and I end up with misaligned rows. for example, I'll start out with one row of data like this

query data manual entry dat
------------- --------------------

and after the refresh i'll end up with this

manual entry dat
query data --------------------
 
Top