Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Keeping cell info intact when sorting worksheets w/some linked cel
I should clarify something re my question below, which was: I have a source
worksheet from which I've linked several other worksheets. If I alpha sort the source worksheet, the sort results are fine -- has column-for-column, row-for-row integrity -- all information in rows stays together with the individual's NAME, which is what is sorted. However, if I sort any worksheet that's linked to my primary worksheet, and I alpha sort the NAMES column, the information from cells in other columns of that row do not sort with it. CLARIFIED: In the secondary worksheets, some cells of columns are linked and some are not. The ones that are linked sort; the cells each row that are not linked to the primary worksheet do not sort. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keeping rows together during column sorts of linked worksheets | Excel Worksheet Functions | |||
Sorting columns while keeping row data intact | New Users to Excel | |||
Keeping formula format intact | Excel Discussion (Misc queries) | |||
Keeping the same format in linked worksheets | Excel Worksheet Functions | |||
keeping rows intact during sort | Excel Discussion (Misc queries) |