Sort data using a button

[malitec]

Hi gurus

I am looking for macros to sort data in 4 columns using a command button. I have to sort data in three different ways using three different buttons-First two buttons to sort data on different criteria and the third button to unsort data.

The columns where data needs to be sorted are column F(work type), column H (Plan expiry date- look for dates higher than TODAY(),column L(days with planner-look for 28 days or more) and column P (Status-look for rows which doesn't says the task is completed)

The first button should look for all type of "Sch Reviews"(there are few types of sch reviews in that column and we need to capture all type) from column F, sort the dates in the descending order;oldest to newest in column H,look for sch reviews sitting with more than 28 days with planner and all sch review tasks are not completed(column P)

The second button should look for all type of "New plans"(there are few types of New plans in that column and we need to capture all type) from column F, look for plans sitting with more than 28 days with planner(sort the days in the descending order;oldest to newest) and all New plans which are not completed(column P).

Third button to unsort each time after a sort button is used.

I tried looking for options from web and came across few in our forum but none of them fulfils the criteria am looking for. Spreadsheet is attached

Requesting your help

regards

[Keebellah]

Hi,
When you sort data in Excel the entire table is sorted and you can choose the number of levels you want.
one column ascending the other descending etc. but NOT look for values higher than or whatever.

When you say Unsort, Excel has no way of knowing what the original sort order was (maybe column B?

You can do this yourself by recording three or more macros.
One for each sorting rule you want.

Just start recording and set the sort rules,

Then just add three buttons and assign the corresponding macro to the corresponding button

[Keebellah]

Is there any particular reason why you have 0 in column BE?

And thinking about what you're asking and some code you have there, is it not that you want to hide and un hide rows based upon your criteria? Maybe sort bay also hide or show rows?

[Keebellah]

And the columns are not F, H, L and P but F, H, K and O
You probably added a column somewhere in between H and L

[Keebellah]

Two macros
SortButton0 sorts the table on Id (column B) I think this would be your 'non sorted' one
SortButton1 sorts on the the four columns, nothing dates, sorts all 4 ascending

The things with dates you'll have to explain better and attach a file with initial situation and what you want.

But, you can play around with these two macros.

Please Login or Register  to view this content.

[malitec]

Thanks Keebellah

I will try these and let you know. Appreciating your time spent on my request.

[malitec]

Thanks Keebellah

The macro works fantastic. Thanks a ton

[Keebellah]

You're welcome
Happy coding