Saving Sort Settings

[ucfchick]

I have 2 workbooks set up exactly the same way but with different data. When
I go to sort one spreadsheet, it keeps the last sort options that I had. On
the other spreadsheet, it will not save the settings so I have to pick them
each and every time. How can I avoid this? I cannot see what I have done
differently on one sprdsht than the other. I have even tried saving a copy of
the one that works and replacing the data with the sprdsht that doesn't. It
just keeps defaulting to the column that my cursor is in at the time.

 

[Dave Peterson]

If you're always doing the same kind of sort, you could record a macro when you
do it once and then just rerun that macro whenever you wanted.

 

[ucfchick]

Ahhhh - didn't even think of that - thanks! Works even better than doing a
manual sort.