Switching Between Multiple Sorts

[swilschutz]

Hello,

I have an excel worksheet with a few thousand rows. What I would lik
to do is to easily switch between different data sorts without going t
the sort menu and reordering the data every time.

Is there an easy way to set up different worksheets to sort the sam
data in different ways?

The data is updated frequently with rows inserted at times. If
wanted the data to automatically sort, could I setup worksheets to sor
the data upon switching to them (using VBA for example)?

I'm open to any suggestions. Much thanks,
Set

 

[Dave Peterson]

I'd guess that all those things are possible. I'd start by doing a sort
manually and recording a macro.

Then depending on what you want, you could run your macro that would sort all
the sheets the same way.