I do not understand what you need, but check out the indirect() function in
Help.
=indirect("AA31") will always refer to AA31, no matter what you do to the
spreadsheet.
"MarcoPolo" wrote:
> I have a rather large worksheet, columns to AN, rows to 369, and currently
> transfers data across about 6 worksheets with more to come. I'm building a
> price list with a long list a variables and then setting the prices into a
> special format, so I cannot afford the data loss. When I sort my list for a
> variety of reasons, the formula references do not maintain the original cell
> references I need. I tried the absolute reference, bad idea. totally lost the
> information. Had to rebuild. Tried partial absolute refernces, some success,
> but a big loss on some.
>
> Is there a good way to build a formula that will allow for cell references
> to remain intact under various data sorts?
> Thanks in advance!
> John
Bookmarks