Click button to Sort by Alpha, then click button to return Original order

A few years ago I managed to get a sort button at the top of a column to sort the numbers in the column
by 'ascending' with the first button click, and then 'descending' with the second button click.

Now I have a slightly trickier situation.

I have 120 names in a particular order in column A.
I need to somehow lock that order in. Call it Order1.

I want to make a button to sort column A by ascending names. Call that Order2.

And so, each time I click the button, it will sort the column, alternating between
Order1 and Order2.

This is a little beyond my capabilities.
Any help is appreciated!

how about sending a sample workbook?

Originally Posted by bob33

how about sending a sample workbook?

Sure.
Here is a sample.

Originally Posted by JeteMc

This doesn't involve buttons but perhaps it will help.
While the names are in original order, number another column 1:120
Select a cell in the names column and then select sort A to Z
to get back to the original sort order select a cell in the numbered column and then select sort A to Z.
Let us know if you have any questions.

Thanks for helping out JeteMC!
That's a pretty cool trick.

A couple of days ago I thought of two other solutions.
The first simply was to add another worksheet to the file.
On that worksheet I copied the column with the 120 names and other associated data.

When I want to sort by alpha I can do it on this second worksheet, preserving the original
name order on the first worksheet.

The other option involves copying the 120 names to another column, out of view on the worksheet.
Then I can sort the names by alpha, and when I need the original order of names again,
I would just copy the names back from the column I added.

It would work because the data to the right of the names all involve formulae, linking to another sheet,
and the name currently in column A.

I decided to go with the first option (extra worksheet), so no button/macro is required.