Help with sorting tabs

[jtees4]

Trying to help my wife who just started a new job. She needs to sort
worksheet tabs, alphabetical would be fine, but other ways would work
too. I did look it up online and frankly didn't quite understand the
answers, I saw the VBA thing as well as some functions.
Is there a relatively easy answer in layman's terms???
Thank you!

 

[Claus Busch]

Hi,

Am Wed, 21 Jan 2015 10:09:09 -0500 schrieb jtees4:

Trying to help my wife who just started a new job. She needs to sort
worksheet tabs, alphabetical would be fine, but other ways would work
too. I did look it up online and frankly didn't quite understand the
answers, I saw the VBA thing as well as some functions.
Is there a relatively easy answer in layman's terms???

if you have only a few tabs you could move them with pressed left mouse
button. Or rightclick on sheet tab => Move/Copy and choose where to
move.
Otherwise press Alt+F11 => Insert => Module and insert a VBA code you
found into the code window. Go back to Excel and run the code.


Regards
Claus B.

 

[jtees4]

Hi,

Am Wed, 21 Jan 2015 10:09:09 -0500 schrieb jtees4:


if you have only a few tabs you could move them with pressed left mouse
button. Or rightclick on sheet tab => Move/Copy and choose where to
move.
Otherwise press Alt+F11 => Insert => Module and insert a VBA code you
found into the code window. Go back to Excel and run the code.


Regards
Claus B.

Thanks Claus, I will try a bit later when I have the file. I had no
clue how to use or access VBA so that is a good thing to know just for
future reference. It is a lot of tabs by the way, probably hundreds.

 

[jtees4]

Thanks again Claus, my wife brought the file home and the vba thing
worked like a charm!