| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
customer sort order in a marco
i need to sort a column in custom order. since this sheet will be open by
multiple users. i cannot add the sort order in excel's custom sort order. can i write the sort order in a marco? or i can save the sort order in specific file? dennis |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
customer sort order in a marco
Dennis,
Go and create your own custom list... follow Tools Options Custom Lists Then once your list is built, it becomes available in the standard Data Sort, where you select your new list as the sort option ... HTH Carim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
customer sort order in a marco
Dennis,
For built-in macro, take a look at the brilliant solution Dave Peterson has developped ... http://groups-beta.google.com/group/...eecb1e0dd06174 HTH Carim |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
customer sort order in a marco
but it didn't work for other users they don't have this order built.
can i save the order in a file? or write it in a marco? Dennis "Carim" wrote in message oups.com... Dennis, Go and create your own custom list... follow Tools Options Custom Lists Then once your list is built, it becomes available in the standard Data Sort, where you select your new list as the sort option ... HTH Carim |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
customer sort order in a marco
If you look at that code again, you'll see that the custom list was added in the
macro. Dennis Cheung wrote: but it didn't work for other users they don't have this order built. can i save the order in a file? or write it in a marco? Dennis "Carim" wrote in message oups.com... Dennis, Go and create your own custom list... follow Tools Options Custom Lists Then once your list is built, it becomes available in the standard Data Sort, where you select your new list as the sort option ... HTH Carim -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retaining Sort order in the Sort Dialog box | Excel Discussion (Misc queries) | |||
| Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
| template for taking customer food order | Excel Worksheet Functions | |||
| Count Duplicates Order numbers for one Customer | Excel Worksheet Functions | |||
| How to Sort Customer List with Specific States | New Users to Excel | |||
![Dennis Cheung[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
