View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GLS
 
Posts: n/a
Default When I sort how do I keep cell references correct?

When I sort a table references to other cells are not maintained properly.

I've tried making them both relative & absolute & either way they no longer
point to the correct cell (which has moved) after the sort is completed.

These are all internal references (within the same table) but on a different
row.