View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
judie judie is offline
external usenet poster
 
Posts: 3
Default 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.