Hi,

I have two excel workbooks - Workbook 1 and workbook 2. There is two columns on each sheet - A and B. One is a driver and one is driven, the breakdown is as follows.

Workbook 1
Column A is Driven by Workbook 2 Column A
Column B is entered here and drives Workbook 2 column B

Workbook 2
Column A is entered here and drives workbook 1 column A
Column B is driven by Workbook 1 column B.

Any thoughts on how to fix this? I have copied and pasted with link but the problem is when i change the sorting of the column A in workbook 2, it also changes on workbook 1 however column B does not change and is therefor out of sync.

I tried to upload an example but it wont let me (i have tried multiple ties in the past with no joy).

Thanks,

Adam