Using Queried Data alongside Manually entered data

I have imported data with the ODBC driver into an excel spreadsheet that
I have created. The data imports fine and it gives me rows of
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 no
data is imported (that's OK, it's supposed to be that way). The data
for these few columns is entered manually and is specific to the
imported data in each row.

I hope i am explaining this correctly. Anyway, what happens is when I
refresh my data, new rows are inserted BUT ONLY IN THE COLUMNS RELATED
TO THE QUERY. That means that any data entered manually in a given row
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 them
work.

Can anyone HELP?!?!?!

GWR


---
Message posted from http://www.ExcelForum.com/

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.

gwrose wrote:
I have imported data with the ODBC driver into an excel spreadsheet that
I have created. The data imports fine and it gives me rows of
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 no
data is imported (that's OK, it's supposed to be that way). The data
for these few columns is entered manually and is specific to the
imported data in each row.

I hope i am explaining this correctly. Anyway, what happens is when I
refresh my data, new rows are inserted BUT ONLY IN THE COLUMNS RELATED
TO THE QUERY. That means that any data entered manually in a given row
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 them
work.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html