ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i sort rows and maintain cell references (https://www.excelbanter.com/excel-worksheet-functions/113371-how-do-i-sort-rows-maintain-cell-references.html)

tfb

how do i sort rows and maintain cell references
 
sounds like a simple task but i can't get it! i want to sort selected rows
of a worksheet using an alpha sort of, say, clm "c". how do i maintain the
original references in clm "a"?

JethroUK©

how do i sort rows and maintain cell references
 
dont use the sort icons

you must select the whole block of data

choose sortdata

choose the column to sort by


"tfb" wrote in message
...
| sounds like a simple task but i can't get it! i want to sort selected
rows
| of a worksheet using an alpha sort of, say, clm "c". how do i maintain
the
| original references in clm "a"?




All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com