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