Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retaining cell reference in destination, when sorting source file
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retaining cell reference in destination, when sorting source file
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.) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retaining cell reference in destination, when sorting source f
I am visiting this site because I am having exactly the same problem, did you
resolve yours? "Mr Reorg" wrote: 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.) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retaining cell reference in destination, when sorting source f
No I haven't. I haven't been monoriting my email; sorry I didnt let you know
sooner. "main" wrote: I am visiting this site because I am having exactly the same problem, did you resolve yours? "Mr Reorg" wrote: 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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation source = destination? | Excel Worksheet Functions | |||
How to update destination file with source files closed? | Excel Discussion (Misc queries) | |||
retaining data after source cells move | Excel Discussion (Misc queries) | |||
XL2003 Destination and Source Open but not updating | Excel Discussion (Misc queries) | |||
Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) |