Transferring Data From Access

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

Thanks for the reply. I think I know just enough to get me into trouble. Is
the formula you are talking of something like VLOOOKUP? I have tried to
understand the help menu for that but am lost.

I have 15 columns of info, the first two come from the DB, the other 13
(which I want to keep with each name) contain either a ‘1’ or are blank.
Does each separate row have a formula?

Any additional help is appreciated.

Phil


"Debra Dalgleish" wrote:

> 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.
>