Transpose Row and Linked Cells.

[omairhe]

Hello folks.... i have some Linked Cells with row range=Sheet4!$B$5:$SI$5
the above Cells are Linked to row range=Sheet1!$B$9:$SI$9

But now in Sheet4 i want to transpose these horizontal row linked cells to a vertical column. After i transpose these values of Sheet1 into same sheet just below the Link Cells formula is not the same and it seems by transposing the value, formulas were transposed aswell.

How to Transpose only the values and not the formulas for link cells.

in this image i have transpose the above row to column but as you can see the formula for link cells got changed....

help will be appreciated
thanks in advance

 

[strive4peace]

copy the range and paste it somewhere else as Values by using Paste Special ... then you can transpose it

 

[omairhe]

its ok now that i've recorded a Relative reference Macro for one cell to link. then pressed the down arrow key and repeated this recorded macro by a shortcut key which did just fine... thanks

 

[strive4peace]

great! glad you got it