ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Newbie w/question (https://www.excelbanter.com/excel-programming/411450-newbie-w-question.html)

aeng1

Newbie w/question
 
How do I customize the list that the 'DATA' sort uses? I need to be able to
sort by my own particular categories. Thank you for any/all your help. A

Jim Cone[_2_]

Newbie w/question
 

Create a list of your categories, in the order that you desire,
and go to Tools | Options | Custom Lists and add your list.
When sorting click the "Options" button on the wizard and choose your custom list.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"aeng1"
wrote in message
How do I customize the list that the 'DATA' sort uses? I need to be able to
sort by my own particular categories. Thank you for any/all your help. A

aeng1

Newbie w/question
 
Thank you very much Jim. I will try it !

"Jim Cone" wrote:


Create a list of your categories, in the order that you desire,
and go to Tools | Options | Custom Lists and add your list.
When sorting click the "Options" button on the wizard and choose your custom list.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"aeng1"
wrote in message
How do I customize the list that the 'DATA' sort uses? I need to be able to
sort by my own particular categories. Thank you for any/all your help. A



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

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