Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting with a macro?
I want to automate a sorting process for a spreadsheet that I have. On
this sheet, I have various groups of names that I want to sort alphabetically within each group. For example, cells A1:A10 should be sorte a-z, cells A11:A20 sorted a-z, etc. I will be updating this list from time to time with more names, and I'll need to resort it each time. There are 10 groups of names that I want sorted, and it's very tedious to select 10 different sets of cells and then tell it how to sort 10 different times. I've created a macro to do this, which works great. My problem is that if I allow 15 cells for each set of names (so, 15 names) and 6 months from now I need to add two rows because I have 17 names in a particular category, the macro I've created won't sort properly, because it's only expecting a range of 15 cells. Is there a way to make a sort function that will take into account a change in the number of cells in a group? (I hope you can understand this from my description) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Macro | Excel Worksheet Functions | |||
Help with Macro for sorting | Excel Worksheet Functions | |||
macro for sorting | Excel Discussion (Misc queries) | |||
Sorting w/Macro | Excel Programming | |||
sorting macro | Excel Programming |