T
tinyguppie
I have a rather large range of data.
I would like to assign a button (or some simple means) so that someone
can easily sort it.
I want it to be simple (and cant use Data->Sort - see below) as all the
data in the array is really a link to another worksheet - meaning it
changes often, so you need to resort often)
What would be the best way to accomplish this?
What further complicates this is that I have quite a few (12) columes
that I want sorted.
Its easier to show with an example
Task October November December January Feb March
1 aaaa X
2 bbbb
3 cccc X
4 xxxx X
5 yyyy X
When the user clicks the button, it would result in the following
Task October November December January Feb March
1 xxxx X
2 yyyy X
3 aaaa X
4 cccc X
5 bbbb
ie - Sort by October, then Nov, then Dec, then Jan, ... etc
Any rows that dont have an X in the column would end up at the bottom.
Under Data->Sort excel only allows you to choose 3 columns to sort by.
I need 12, one for each month.
Re-arraning the spreadsheet really isnt an option since i need to make
this work without chaning the format.
Any help is much appreciated
Thank You in advance.
I would like to assign a button (or some simple means) so that someone
can easily sort it.
I want it to be simple (and cant use Data->Sort - see below) as all the
data in the array is really a link to another worksheet - meaning it
changes often, so you need to resort often)
What would be the best way to accomplish this?
What further complicates this is that I have quite a few (12) columes
that I want sorted.
Its easier to show with an example
Task October November December January Feb March
1 aaaa X
2 bbbb
3 cccc X
4 xxxx X
5 yyyy X
When the user clicks the button, it would result in the following
Task October November December January Feb March
1 xxxx X
2 yyyy X
3 aaaa X
4 cccc X
5 bbbb
ie - Sort by October, then Nov, then Dec, then Jan, ... etc
Any rows that dont have an X in the column would end up at the bottom.
Under Data->Sort excel only allows you to choose 3 columns to sort by.
I need 12, one for each month.
Re-arraning the spreadsheet really isnt an option since i need to make
this work without chaning the format.
Any help is much appreciated
Thank You in advance.
Help!!!