Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Re my question on sorting
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. DOUBLE-HELP!!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Re my question on sorting
Do you still need the links? the fomulas will not change when yhou do the
sort as you can see. One solution is to remove the links by copying the page with the links and Paste Special with the values. This will replace the links with the values of the cell. "judie" wrote: 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. DOUBLE-HELP!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting question | New Users to Excel | |||
SORTING question | New Users to Excel | |||
Row sorting question | Excel Discussion (Misc queries) | |||
sorting question | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel |