Thread: Preserving Formula References During Sort

I am building a template in an excel worksheet for logging records. The template includes several macros with the Range.Sort method. The log includes values that reference each other - for instance Row3.Value = Row1.Value + Row2.Value. However if Row2.Value gets sorted to Row 5, the formula will still reference Row 2, even though the referenced value has moved to Row 5. Is there anyway to preserve dynamic referencing when sorting, where the reference is associated with the data and not the cell? I've also tried naming the cell, but that didn't work. I guess I'm expecting Excel to act like a database.

Thanks for the help.