View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tbobster
 
Posts: n/a
Default Referencing to cells in a sorted list

I have a list in a spreadsheet. In another part of the spreadsheet, I am
referring to cells in the list. When I sort the list, the cells referenced
have different data in them. Is there a way to reference the list so that
cells referring to the fields in the list follow the specific item to which
they are referring?

Is this clear?