View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
judie judie is offline
external usenet poster
 
Posts: 3
Default keeping rows together during column sorts of linked worksheets

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.

DESPERATE -- Help!!!