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.