ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Button to sort a range, and sorting 12 columns (https://www.excelbanter.com/excel-worksheet-functions/115048-button-sort-range-sorting-12-columns.html)

[email protected]

Button to sort a range, and sorting 12 columns
 
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.


[email protected]

Button to sort a range, and sorting 12 columns
 
Any responses?????? Please!!!!! :) Help!!! :)


[email protected]

Button to sort a range, and sorting 12 columns
 
guess not!
:(
wrote:
Any responses?????? Please!!!!! :) Help!!! :)




All times are GMT +1. The time now is 12:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com