How to click on different cells to get the spreadsheet to sort various ways

[JET2011]

How to click on different cells to get the spreadsheet to sort various ways

I'd like to be able to click on a cell and have the spreadsheet sorted automatically. My data is in A2 to T400. I'd like to be able to click on cell A1 then its sorted by column B part # (ascending). Click on cell A2 then sorts by column F defects (descending) click on cell A3 sort by column M description (ascending). It would be nice if the cells you click to sort clearly has the description of what the sort is.

Somewhat limited so will need pretty good details.

Thanks for any ideas -

-j

[protonLeah]

Just use the built-in Filter functionality. Click in the data table and select Filter from the Sort and Filter Menu. Then use the dropdown in the header row of the column you want to sort by.

[NC Training Services]

if you want to sort as a secondary sort, ie the first column you sorted by stays the same, then on the Data Tab choose the BIG sort button. Add the first Sort option then press the ADD Level button then set up the secondary sort.

if it is just by one column, you don't have to highlight data (unless you have random blank columns that is). if you use the Sort buttons on the Data tab (or Home tab) it will sort by the column you are clicked in, so, if you were in A20 that would sort by column A and take all the relevant corresponding data with it.

[JET2011]

I'm really looking to make this super easy for those who I want to encourage to review the data in the spreadsheet, it it's not for me although clicking one cell to sort much easier than carefully selecting all the data then sorting.

Be most grateful for any solution.

-j

[NC Training Services]

it would take time to set up but be super easy for the delegates if you recorded the steps you wanted as a macro and then create a button on each screen for the delegates to just press the button then the sort would happen. On the View tab of the ribbon at the end is where you would find the option to record a macro, however, I would recommend getting someone in to help you if you haven't recorded a macro before as you will need to fully know what you are doing on every step. that would work very well and couldn't be easier for them to use, just will take a little setting up.

[JET2011]

NC Training thanks. Recording the macro worked out nice and looks cool too.
There are two steps. First record the moves you want saved. Recording macro is found under developer. If you cant find it you may need to go to file then options and make sure developer is checked. Select record macro. The make all the moves you want saved then select stop recording.
Now assign this recording (macro) -- Under developer tab select insert then form control box (there is a bunch of different styles - I like the square box so you can spell out what the macro will do when clicked ie sort by name.) After you select and inserted your form control box, then right click it and assign your macro.

Hope it help another beginner - macros help not knowing VBA.

-j