ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   simple sort, but ... (https://www.excelbanter.com/excel-discussion-misc-queries/113362-simple-sort-but.html)

tfb

simple sort, but ...
 
should be simple but i can't get it ... i want to do an alpha sort of
selected rows using the data in clm "c" for the sort criteria ...and i want
to maintain the original cell references in the rest of the selection!
anybody?

Nick Hodge

simple sort, but ...
 
Try importing your sort 'list' into ToolsOptions...Custom Lists

Once done, select the data you want to sort and then select DataSort...
Select Options and in the 'first sort order' drop down select you 'list'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"tfb" wrote in message
...
should be simple but i can't get it ... i want to do an alpha sort of
selected rows using the data in clm "c" for the sort criteria ...and i
want
to maintain the original cell references in the rest of the selection!
anybody?





All times are GMT +1. The time now is 02:40 PM.

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