Saving Multiple Sorts

[david0985]

Hi everyone,

I have a master spreadsheet that contains a ton of information. Depending on the audience for a meeting, I want the rows sorted in different ways. Is there a way to save "Sort 1" which sorts by criteria A, then B, then C, and then save "Sort 2" which sorts by criteria D, E, then F?

Basically, I want to be able to toggle between multiple sorts without having to recreate these sorts every time I switch between them.

Thanks in advance!
David

[Pete_UK]

You could highlight the sorted data then click on Copy then use Paste Special | Values and Paste Special | Formats to another sheet.

Hope this helps.

Pete

[sbkeenan]

You could create sort macros and assign them to buttons. Just click on the button to sort in that order.

[david0985]

Thanks for the responses.

pete - i am looking to stay away from making multiple instances of the spreadsheet since the data changes daily.

keenan - i think that is my best course of action right now, thanks for the suggestion.

My original thought was to create a concatenation column of all of my sort criteria way off to the right, and then sort on whichever concatenation column I wanted. I don't think it will work in all cases though because the data in my grid is a mix of numbers and text.

[Amanda Wilso]

Check the link and hope you will find the informations you need:

https://www.exceltip.com/excel-filte...-criteria.html

[Amanda Wilso]

Check the link and hope you will find the informations you need:

https://www.exceltip.com/excel-filte...-criteria.html