Need help writing sorting macros

**MannyLNJ** · 07-02-2012, 04:19 PM

I am working on a spreadsheet to help me with my finances. in the future I may offer it to others for a fee or I may give it away for free. I need help and I'm figuring that this is one of the best places to ask. I do not want code written but pointers to where I can learn how to do this because unless I learn how and why I won't be able to modify it in the future.

The current spreadsheet is uploaded to this post the account names and values are not real just dummy values for now.

What I want to do is add the following sort options

1) Sort by Highest APR only
2) Sort by Highest APR then util, % (example if two cards have a 18.99% Apr put the one that's closest to being max'ed out on the top)
3) Sort by Utilization only.
4) Sort by lowest balance

I need the sort to ignore any cards where the amount owed is 0

I do appreciate any help given.

**deadlyduck** · 07-02-2012, 05:04 PM

Would you consider using an Excel table (or list in Excel 2003) to do this? This puts arrows at the top of each column with various sort options.
You would ideally delete the blank column E to do this to include the Util column.

In Excel 2007, click on any cell containing the data you want to be able to sort and then 'Insert | Table'.

**MannyLNJ** · 07-02-2012, 05:07 PM

Originally Posted by deadlyduck

Would you consider using an Excel table (or list in Excel 2003) to do this? This puts arrows at the top of each column with various sort options.
You would ideally delete the blank column E to do this to include the Util column.

In Excel 2007, click on any cell containing the data you want to be able to sort and then 'Insert | Table'.

I have not considered a table only because if I do distribute this I want to make it simple for whoever is using it. I was going to have a radio button to run the sort function chosen.

**deadlyduck** · 07-02-2012, 05:13 PM

OK.
What I'd do is the following:

Record a macro for each type of sort that you would like to run. So if for example you wanted to only sort by APR ascending and APR descending then you'd record 2 macros.
Insert buttons or whatever type of control you want on the sheet containing data for each type of sortto
Assign the relevant macro to each button as appropriate e.g. for a Sort APR ascending button, you'd assign the macro you recorded to do that type of sort.

I'm sure that there are much more efficient methods- one of the many gurus here will likely improve on the above idea.

**MannyLNJ** · 07-02-2012, 09:51 PM

Thanks for the suggestion. I will try that when I'm on my main PC. I dislike the Excel Starter edition that came on my laptop. It doesn't have the featues I need