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


GLS,

I've stumbled through this before, without a good solution.

Clumsy solutions which I've used and which you may try are to either
(a) re-write the formulas to use vlookup or sumif features, or (b) use
helper calculations on another worksheet. When you sort the main
worksheet, the references to the helper sheet remain correct.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=490197