Retaining cell reference in destination, when sorting source file

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

Mr Reorg

By the way, I'm using Excel 2003. (I had to add a reply to my own post
'cause I didn't see any Edit button.)
 
M

main

I am visiting this site because I am having exactly the same problem, did you
resolve yours?
 
M

Mr Reorg

No I haven't. I haven't been monoriting my email; sorry I didnt let you know
sooner.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top