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