Help with sorting tabs


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!
 
Ad

Advertisements

C

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.
 
J

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.
 
Ad

Advertisements

J

jtees4

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top