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. |
Button to sort a range, and sorting 12 columns
Any responses?????? Please!!!!! :) Help!!! :)
|
Button to sort a range, and sorting 12 columns
|
All times are GMT +1. The time now is 12:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com