| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Sorting a linked work sheet
Hi
I have a set of simple work sheets with cells containing formula. I have linked the cells by the copy, paste and link method. I can cut and paste the prime cells and the links follow. However when I do a custom sort of the prime data the links remain and do not follow to the cells new location. There must be a simple answer but I cannot find it and would appreciate help on this question. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Sorting a linked work sheet
That's the way excel works.
Maybe you can find a unique key into that table sheet. Then you could use =vlookup() or =index(match()) (using that unique key) so that you get the values you want. Debra Dalgleish has lots of notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble Derro wrote: Hi I have a set of simple work sheets with cells containing formula. I have linked the cells by the copy, paste and link method. I can cut and paste the prime cells and the links follow. However when I do a custom sort of the prime data the links remain and do not follow to the cells new location. There must be a simple answer but I cannot find it and would appreciate help on this question. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Sorting a linked work sheet
Thanks again Dave I will work around
"Dave Peterson" wrote: That's the way excel works. Maybe you can find a unique key into that table sheet. Then you could use =vlookup() or =index(match()) (using that unique key) so that you get the values you want. Debra Dalgleish has lots of notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble Derro wrote: Hi I have a set of simple work sheets with cells containing formula. I have linked the cells by the copy, paste and link method. I can cut and paste the prime cells and the links follow. However when I do a custom sort of the prime data the links remain and do not follow to the cells new location. There must be a simple answer but I cannot find it and would appreciate help on this question. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting source data linked to another sheet | Excel Worksheet Functions | |||
| Sorting data on one sheet, linked to another, but staying the same | Excel Discussion (Misc queries) | |||
| Linked cells from master data sheet and sorting | Excel Worksheet Functions | |||
| Problem created by sorting linked sheet | Excel Discussion (Misc queries) | |||
| sorting master sheet messes up cells in other sheets linked to it | Excel Worksheet Functions | |||
Hybrid Mode
