Reversing cells

[Guest]

I have a range of cells with misc. data Say a1:r10
I wish to rearrange them so that the value in r10 becomes the value ina1and
so on

oldjay

 

[Jim Cone]

Something to try...
Add a header row and header column with consecutive numbers in them.
Sort the data Right to Left - descending - using the header row as the key.
Sort the data Top to Bottom descending - using the header column as the key.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Oldjay" <[email protected]>
wrote in message
I have a range of cells with misc. data Say a1:r10
I wish to rearrange them so that the value in r10 becomes the value ina1and
so on
oldjay

 

[Guest]

Thanks Tt did the trick!
oldjay