The data typed adjacent to the external data isn't connected to the
names, so won't automatically shift if the imported data changes.

You could enter the data in the database, connecting it to the names.
Or, create a lookup table of names and data in the Excel workbook, and
use formulas adjacent to the external data, to display the matching data.

philhert wrote:
I have set up a worksheet to Get External Data from my DB (ex LastName,
FirstName). I then use the worksheet to input additonal data for each row.
When I refresh the Data (after I have made changes in the DB), is there a way
to preserve the row info, as new names may be inserted in between original
names?

Ex. co1 col2 col3 col4
orig data: jones tom xxx xxx
wesson mike xxx

after refresh: jones tom xxx xxx
smith joe xxx
wesson mike

wanted: jones tom xxx xxx
smith joe
wesson mike xxx


Is it possible to preserve the row data?

thanks for any help

phil


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html