| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links and sorting
Can one worksheet be copied to another in the same book with a link that
updates info and can each sheet be sorted differently and still carry the correct info? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links and sorting
If the two ranges would be "connected" by a single column that uniquely
identifies the row of information, then in the second table, use the vlooup or combination of index and match to fill out the rest of the data by pulling it from the first. . -- Regards, Tom Ogilvy "Mex" wrote in message ... Can one worksheet be copied to another in the same book with a link that updates info and can each sheet be sorted differently and still carry the correct info? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting loses links to data | Links and Linking in Excel | |||
| Sorting multiple worksheets simultaneously | Excel Discussion (Misc queries) | |||
| sorting without affecting links | Excel Discussion (Misc queries) | |||
| Maintaing formula links when sorting | Excel Discussion (Misc queries) | |||
| sorting links | Links and Linking in Excel | |||
Linear Mode
