Home

Linking cells

%3CLINGO-SUB%20id%3D%22lingo-sub-793380%22%20slang%3D%22en-US%22%3ELinking%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793380%22%20slang%3D%22en-US%22%3E%3CP%3ESo%2C%20I%20need%20to%20sort%20my%20data%20from%20smallest%20values%20to%20largest%20while%20also%20keeping%20the%20cells%20connected%20with%20their%20corresponding%20cell%20in%20another%20column.%20How%20do%20I%20do%20this%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-793380%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-793393%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-793393%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F388659%22%20target%3D%22_blank%22%3E%40daniellegygi%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20similar%20question%20was%20asked%20a%20couple%20of%20weeks%20ago%2C%20refer%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fmaintaining-a-cell-reference-despite-changing-the-cell-location%2Fm-p%2F774313%23M37153%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fmaintaining-a-cell-reference-despite-changing-the-cell-location%2Fm-p%2F774313%23M37153%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThough%20a%20practical%20solution%20was%20not%20found.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
daniellegygi
Occasional Visitor

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.