Hi,

In workbook A there is a column for names that links to workbook B (source data); then the next column of workbook A has phone numbers (entered directly in that workbook).

When I sort the names column in work book B; the order of names also change with workbook A (as they are linked).

But then the phones column becomes out of sync with the names column in workbook A (as this later column didn't change move together with the names column)

Is there any manner of solving this, and ensuring both columns remain in sync?

It would work for me either for: name column in workbook A not changing when I sort the linked column in B; or for the other columns in A to move together with changes to the column linked to workbook B.

Thanks!

Renato