software

I have a table in excel that has formulas in the rows. When I sort the
table, the addresses in the formulas do not translate to the new location
after the sort. I am not using absolute addressing. This is confirmed
because the address do translate when I drag them to the next row. How can I
make the addresses translate after sorting?

Nothing built will take care of that, there are some workarounds here

www.mvps.org/dmcritchie/excel/offset.htm

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Matt@Majorquot; gt; wrote in message
...
gt;I have a table in excel that has formulas in the rows. When I sort the
gt; table, the addresses in the formulas do not translate to the new location
gt; after the sort. I am not using absolute addressing. This is confirmed
gt; because the address do translate when I drag them to the next row. How
gt; can I
gt; make the addresses translate after sorting?