Ask Your Question

Revision history [back]

Hello.

Please see this topic about updating cell references while sorting data. Pay attention to @Lupp provided information - there are issues when Update references... are enabled.

Hello.

Please see this topic about updating cell references while sorting data. Pay attention to @Lupp provided information - there are issues when Update references... are enabled.

You can also copy information needed to new sheet using Paste Special and copying only values, nor formulas, so after sorting values will be kept unchanged.

Hello.

Please see this topic about updating cell references while sorting data. Pay attention to @Lupp provided information - there are issues when Update references... are enabled.

You can also copy information needed to new sheet using Paste Special and copying only values, nor not formulas, so after sorting this new sheet values will be kept unchanged.