Linking cells

Copper Contributor

So, I need to sort my data from smallest values to largest while also keeping the cells connected with their corresponding cell in another column. How do I do this? Thanks!

1 Reply

Hello @daniellegygi,

 

A similar question was asked a couple of weeks ago, refer here:

https://techcommunity.microsoft.com/t5/Excel/maintaining-a-cell-reference-despite-changing-the-cell-...

 

Though a practical solution was not found.