Help with sorting tabs

  • Thread starter Thread starter jtees4
  • Start date Start date
J

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!
 
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???
Click to expand...

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.
 
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.
Click to expand...

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.
 
Back
Top