M
Mr Reorg
Whenever I sort the data in my source workbook, the cells in my destination
workbook loose the initial data referenced, and behave as absolute
column/absolute row references, even though I am using absolute
column/relative row reference in the formula. If I only add rows to the
source file, the cell references behave corectly, changing their row values.
How do I get the cell reference to follow the sorting of the source workbook?
This is the SOURCE before sorting:
A1 = name 1 B1 = nickname 1 C1 = 15
A2 = name 2 B2 = nickname 2 C2 = 5
A3 = name 3 B3 = nickname 3 C3 = 2
This is the DESTINATION before sorting the SOURCE:
A1 = Source $A1 B1 = Source $A2 C1 = Source $A3
A2 = Source $B1 B2 = Source $B2 C2 = Source $B3
A3 = Source $C1 A3 = Source $C2 A3 = Source $C3
I want the values (data) of the DESTINATION file to remain constant even
though the source file gets sorted; I do not want the Destination file to get
jumbled. If the data in the Source gets updated/changed, I want that change
to flow into the Destination file.
workbook loose the initial data referenced, and behave as absolute
column/absolute row references, even though I am using absolute
column/relative row reference in the formula. If I only add rows to the
source file, the cell references behave corectly, changing their row values.
How do I get the cell reference to follow the sorting of the source workbook?
This is the SOURCE before sorting:
A1 = name 1 B1 = nickname 1 C1 = 15
A2 = name 2 B2 = nickname 2 C2 = 5
A3 = name 3 B3 = nickname 3 C3 = 2
This is the DESTINATION before sorting the SOURCE:
A1 = Source $A1 B1 = Source $A2 C1 = Source $A3
A2 = Source $B1 B2 = Source $B2 C2 = Source $B3
A3 = Source $C1 A3 = Source $C2 A3 = Source $C3
I want the values (data) of the DESTINATION file to remain constant even
though the source file gets sorted; I do not want the Destination file to get
jumbled. If the data in the Source gets updated/changed, I want that change
to flow into the Destination file.