|
Reversing cells
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 |
Reversing cells
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" 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 |
Reversing cells
Thanks Tt did the trick!
oldjay "Jim Cone" wrote: 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" 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 |
| All times are GMT +1. The time now is 07:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com