#1
|
|||
|
|||
custom sort macro
I need a macro that will let me reuse the last custom sort that I did. So if the last custom sort that I did sorted by column, sorted on values, and then sorted order using a custom list, I want a macro that lets me use the exact same custom sort on the next selection of cells that I choose without having to go through the whole custom sort again. Is there a macro that can do this?
thanks Last edited by ewso; 09-16-2017 at 12:29 AM. |
#2
|
||||
|
||||
Perhaps post a small sample sheet showing some data and expected results?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Quote:
Is there a way for excel to remember what custom sort I used last and to reuse it again without having to go through the custom sort wizard every time? I do a lot of sorts where I click on the custom sort button, sort by name, values, and then I use a custom list of names. The custom list changes quite a bit though, so I would need to be able to just have excel remember what custom sort rules I used the last time and quickly let me use them again. |
#4
|
||||
|
||||
Please post a sample as requested and expected results
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
I don't know what I would put in a sample. I basically just want to reuse the last custom sort I used on whatever data I choose without having to manually put in all the sort criteria every time. The sort usually looks like this...
Sort by: Column A, Sort on: Values, Order: Custom List ..The custom list changes all the time though. That's why I hope excel can remember the last custom sort I used so I can just click a button and have it sort any data I select using the same criteria and list of the last custom sort I used. |
#6
|
||||
|
||||
Record a macro while applying your custom sort.
You can then reuse it after adapting the code to variable ranges
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#7
|
|||
|
|||
What do I do after I record the custom sort? I no longer need the list I used when recording the sort.
|
#8
|
|||
|
|||
Is there any way that this can be done?
thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to sort columns | SerenityNetworks | Excel Programming | 4 | 09-02-2016 06:20 AM |
VBA Sort Custom Order | tandchas | Excel Programming | 1 | 04-15-2016 05:38 PM |
Custom sort - two header_lines? | Officer_Bierschnitt | Excel | 1 | 11-19-2015 07:48 AM |
Remove the * from the SubCate, Custom Sort, Replace..Help Please - I need. Thanks | shilabrow | Excel Programming | 2 | 07-10-2014 11:09 AM |
Generic range for custom sort macro? | tswiers | Excel Programming | 2 | 08-11-2011 02:40 AM |