Dynamic Range Sort

[lapta301]

Dear All

I have a range of data including headings that currently extends from B3 to I73 but this may grow.

I would like a piece of code that I will attach to a button which when selected will ask the user if the sort is to be "YTD" or "Current Month". I suppose there will also be a need to cancel if they change their mind

If the "YTD" option is selected then the sort is on a field "Rank on YTD" and if "Current Month" then the sort field is "Rank on this Month".

I appreciate that this is relatively straight forward but I need to cover the fact that the rows and columns may extend.

As always many thanks for any help that you can provide.

 

[stanleydgromjr]

lapta301,

If the "YTD" option is selected then the sort is on a field "Rank on YTD" and if "Current Month" then the sort field is "Rank on this Month".

In row 3, your headings extend from B3 to I73 (but this may grow).

What column are the headings in?
"Rank on YTD"
"Rank on this Month"

Sorting ascending or descending?

And, what column always has data in it?


Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4.
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php



Have a great day,
Stan

 

[lapta301]

Stanley

They are currently in H & I respectively but this will probably change.

Is it possible to identify the columns by the name which I could ensure doesn't change?

The actual data range without headings is B4 to I73 and the sort order is ascending.

There will usually be data in all columns but for the sake of an absolute, there will always be something in column B.

 

[stanleydgromjr]

lapta301,

In order to make this dynamic, a screenshot would really help.


Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Colo's HTML Maker.
http://www.puremis.net/excel/downloads.shtml

Instructions for using "Colo's HTML Maker":
http://www.mrexcel.com/forum/showthread.php?t=89356


Or, with Excel Jeanie HTML 4.
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php


Have a great day,
Stan

 

[lapta301]

Stanley

I'm having a good look at what I am doing and how to make life easier all round so give me a day or so and I'll get back to you.

Many thanks


lapta301