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.

Any responses?????? Please!!!!! :) Help!!! :)

guess not!
:(
wrote:
Any responses?????? Please!!!!! :) Help!!! :)