| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sorting mixed up linked cells in a workbook?
We have linked cells in multiple worksheets (one workbook) that do not like
it when we sort. Is there a suggestion about how to have linked cells lock even when sorting the data? |
|
#2
|
|||
|
|||
|
Hi
AFAIK this is not possible -- Regards Frank Kabel Frankfurt, Germany "Destiny" schrieb im Newsbeitrag ... We have linked cells in multiple worksheets (one workbook) that do not like it when we sort. Is there a suggestion about how to have linked cells lock even when sorting the data? |
|
#3
|
|||
|
|||
|
If you have a nice key column with unique entries in both worksheets, maybe you
could replace your formulas with either =vlookup() or =index(match()). Debra Dalgleish has some nice instructions at: http://www.contextures.com/xlFunctions02.html Destiny wrote: We have linked cells in multiple worksheets (one workbook) that do not like it when we sort. Is there a suggestion about how to have linked cells lock even when sorting the data? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update linked cells within a workbook??? | Links and Linking in Excel | |||
| Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
| Sorting referenced cells | New Users to Excel | |||
| how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
| Delete contents of unprotected cells in workbook | Excel Worksheet Functions | |||
Linear Mode
