| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking messed up when Sorting
I have a question about linking. I wanted to link areport to 4 other reports
by department. I just tried it but if I sort the original report it screws up the other reports. Is there a way of linking the appropriate line or person so even when I sort it won't change? Any suggestions would be greatly appreciateed! Thanks! Jugglertwo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking messed up when Sorting
Maybe...
If you can find a nice unique value in each row, you could use =vlookup() or =index(match()) to return the data associated with that key. You may want to read Debra Dalgleish's notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) Jugglertwo wrote: I have a question about linking. I wanted to link areport to 4 other reports by department. I just tried it but if I sort the original report it screws up the other reports. Is there a way of linking the appropriate line or person so even when I sort it won't change? Any suggestions would be greatly appreciateed! Thanks! Jugglertwo -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking then Sorting Objects of the Link - Is this feasible? | Excel Discussion (Misc queries) | |||
| Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
| Linking between worksheets- then sorting data | Excel Worksheet Functions | |||
| Adding a KeyID column for sorting | New Users to Excel | |||
| Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
Linear Mode
