Realigning Referenced cells to thier proper row/columns after sort.

[Festus Hagen]

Hi all,

Not even sure I'm speaking the right terms so please bear with me ...

Typically I include an ID column or row serialized to use to realign referenced cells to their original locations after sorts. I am cleaning up anothers creation.

Is there a faster technique other then a lookup and for loop digging out the elements for getting the column number and row number from an Absolute A1 notation text string ...

ie: Turning "=$A$1" into 1 by 1 or "=$X$50" into 26 by 50

Hopefully I've explained it clearly and correctly ...

Thanks

-Enjoy
fh : )_~

 

[GlennUK]

Hi,

where are you getting the "=$A$1" or "=$X$50" from? They look like cell formulas. Are trying to find where the precedent cell of a cell is? Is this all in VBA? Or do you want cell formulas for this?

 

[Festus Hagen]

Sorry, been off on a trip ...

I want to return the links back to their original locations...

Example: Sheet1 is a data table... I Selected the data and copied to Sheet2 and pasted links, then sheet2 got sorted, I want to put them back in their original places without recopying ...

So currently in cell A1 is the link '=$X$50', I want that '=$X$50 moved back to col=x, row=50.

Like a Defrag ... It'll have to move them from sheet to sheet or to a "Temp" location in the current sheet and then back when done to prevent overwriting.

Yes, I know I could just re-paste the links, that is not what I want to do.

Thanks ...

-Enjoy
fh <font color="#FF0000">:</font> )_~

 

[GlennUK]

Yes, I know I could just re-paste the links, that is not what I want to do.

Why? That'll do exactly what you want.

 

[Festus Hagen]

Curiosity ... Education ...

-Enjoy
fh : )_~