Using Queried Data alongside Manually entered data

[gwrose]

I have imported data with the ODBC driver into an excel spreadsheet tha
I have created. The data imports fine and it gives me rows o
information - each row including name, lot number, contract date
etc.(these would be the columns).

There are numerous columns that i have on this spreadsheet to which n
data is imported (that's OK, it's supposed to be that way). The dat
for these few columns is entered manually and is specific to th
imported data in each row.

I hope i am explaining this correctly. Anyway, what happens is when
refresh my data, new rows are inserted BUT ONLY IN THE COLUMNS RELATE
TO THE QUERY. That means that any data entered manually in a given ro
DOES NOT SHIFT with the insertion or deletion of rows via the query.

I've tried the three options in data range properties, but none of the
work.

Can anyone HELP?!?!?!

GW

 

[Debra Dalgleish]

Excel has no way of connecting the manually entered data to what's
imported to a specific row of the external data range. You could use
formulas to lookup data from another table, and the formula results
would change to reflect the data currently in the row.