Macro to alphabatize your sheet tabs?

[Jennifer]

I have a workbook created by someone else with about 50 different sheet tabs.
Each tab is a part number. I would like to organize them alphabetically but
it is quite a chore since there are so many. Is there a macro I can use that
will automatically put them in alphabetical order?

Thanks in advance for any help!

Jennifer

[Bob Phillips]

http://www.cpearson.com/excel/sortws.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jennifer" <[email protected]> wrote in message
news:[email protected]...
> I have a workbook created by someone else with about 50 different sheet
tabs.
> Each tab is a part number. I would like to organize them alphabetically
but
> it is quite a chore since there are so many. Is there a macro I can use
that
> will automatically put them in alphabetical order?
>
> Thanks in advance for any help!
>
> Jennifer

[Jennifer]

Wow, you're fast :-) Thanks!

"Bob Phillips" wrote:

> http://www.cpearson.com/excel/sortws.htm
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Jennifer" <[email protected]> wrote in message
> news:[email protected]...
> > I have a workbook created by someone else with about 50 different sheet
> tabs.
> > Each tab is a part number. I would like to organize them alphabetically
> but
> > it is quite a chore since there are so many. Is there a macro I can use
> that
> > will automatically put them in alphabetical order?
> >
> > Thanks in advance for any help!
> >
> > Jennifer
>
>
>

[Bob Phillips]

I only had to point you at the solution :-)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jennifer" <[email protected]> wrote in message
news:[email protected]...
> Wow, you're fast :-) Thanks!
>
> "Bob Phillips" wrote:
>
> > http://www.cpearson.com/excel/sortws.htm
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Jennifer" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have a workbook created by someone else with about 50 different
sheet
> > tabs.
> > > Each tab is a part number. I would like to organize them
alphabetically
> > but
> > > it is quite a chore since there are so many. Is there a macro I can
use
> > that
> > > will automatically put them in alphabetical order?
> > >
> > > Thanks in advance for any help!
> > >
> > > Jennifer
> >
> >
> >

[Traveller]

Perhaps I'm missing something, but I think all you have to do is right-click
on the name of one sheet, choose "Select all sheets," then right-click again
and choose "Sort" ascending or desending.

"Jennifer" wrote:

> I have a workbook created by someone else with about 50 different sheet tabs.
> Each tab is a part number. I would like to organize them alphabetically but
> it is quite a chore since there are so many. Is there a macro I can use that
> will automatically put them in alphabetical order?
>
> Thanks in advance for any help!
>
> Jennifer

[[email protected]]

Traveller

sorry but; Excel sucks balls. Only in Access can you right-click SORT
like that.

-Aaron


Traveller wrote:
> Perhaps I'm missing something, but I think all you have to do is right-click
> on the name of one sheet, choose "Select all sheets," then right-click again
> and choose "Sort" ascending or desending.
>
> "Jennifer" wrote:
>
> > I have a workbook created by someone else with about 50 different sheet tabs.
> > Each tab is a part number. I would like to organize them alphabetically but
> > it is quite a chore since there are so many. Is there a macro I can use that
> > will automatically put them in alphabetical order?
> >
> > Thanks in advance for any help!
> >
> > Jennifer

[Traveller]

Sorry, Aaron, I guess I wasn't clear. I meant to right-click on the worksheet
name tabs, which brings up a sub-menu. Then you choose your options normally
by left-clicking.

Jennifer is asking about sorting the tabs in the lower left-hand corner of
the sheet; that's where you right-click to bring up the sub-menues.

"[email protected]" wrote:

> Traveller
>
> sorry but; Excel sucks balls. Only in Access can you right-click SORT
> like that.
>
> -Aaron
>
>
> Traveller wrote:
> > Perhaps I'm missing something, but I think all you have to do is right-click
> > on the name of one sheet, choose "Select all sheets," then right-click again
> > and choose "Sort" ascending or desending.
> >
> > "Jennifer" wrote:
> >
> > > I have a workbook created by someone else with about 50 different sheet tabs.
> > > Each tab is a part number. I would like to organize them alphabetically but
> > > it is quite a chore since there are so many. Is there a macro I can use that
> > > will automatically put them in alphabetical order?
> > >
> > > Thanks in advance for any help!
> > >
> > > Jennifer
>
>

[Gord Dibben]

Traveller

Did you try your method?


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 10:08:01 -0700, Traveller
<[email protected]> wrote:

>Perhaps I'm missing something, but I think all you have to do is right-click
>on the name of one sheet, choose "Select all sheets," then right-click again
>and choose "Sort" ascending or desending.
>
>"Jennifer" wrote:
>
>> I have a workbook created by someone else with about 50 different sheet tabs.
>> Each tab is a part number. I would like to organize them alphabetically but
>> it is quite a chore since there are so many. Is there a macro I can use that
>> will automatically put them in alphabetical order?
>>
>> Thanks in advance for any help!
>>
>> Jennifer

[Bob Phillips]

Maybe in your Excel, but none that I have (97, 2000 or XP).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Traveller" <[email protected]> wrote in message
news:[email protected]...
> Sorry, Aaron, I guess I wasn't clear. I meant to right-click on the
worksheet
> name tabs, which brings up a sub-menu. Then you choose your options
normally
> by left-clicking.
>
> Jennifer is asking about sorting the tabs in the lower left-hand corner of
> the sheet; that's where you right-click to bring up the sub-menues.
>
> "[email protected]" wrote:
>
> > Traveller
> >
> > sorry but; Excel sucks balls. Only in Access can you right-click SORT
> > like that.
> >
> > -Aaron
> >
> >
> > Traveller wrote:
> > > Perhaps I'm missing something, but I think all you have to do is
right-click
> > > on the name of one sheet, choose "Select all sheets," then right-click
again
> > > and choose "Sort" ascending or desending.
> > >
> > > "Jennifer" wrote:
> > >
> > > > I have a workbook created by someone else with about 50 different
sheet tabs.
> > > > Each tab is a part number. I would like to organize them
alphabetically but
> > > > it is quite a chore since there are so many. Is there a macro I can
use that
> > > > will automatically put them in alphabetical order?
> > > >
> > > > Thanks in advance for any help!
> > > >
> > > > Jennifer
> >
> >

[Traveller]

Absolutely. Works great for me (Excel 2003). I don't think I've done anything
special to my Excel. Maybe I'm still not explaining it very well. I'll check
the help files and see if I can come up with clearer instructions.

"Gord Dibben" wrote:

> Traveller
>
> Did you try your method?
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 9 Aug 2006 10:08:01 -0700, Traveller
> <[email protected]> wrote:
>
> >Perhaps I'm missing something, but I think all you have to do is right-click
> >on the name of one sheet, choose "Select all sheets," then right-click again
> >and choose "Sort" ascending or desending.
> >
> >"Jennifer" wrote:
> >
> >> I have a workbook created by someone else with about 50 different sheet tabs.
> >> Each tab is a part number. I would like to organize them alphabetically but
> >> it is quite a chore since there are so many. Is there a macro I can use that
> >> will automatically put them in alphabetical order?
> >>
> >> Thanks in advance for any help!
> >>
> >> Jennifer
>
>

[[email protected]]

I dont see that functionality either


Bob Phillips wrote:
> Maybe in your Excel, but none that I have (97, 2000 or XP).
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Traveller" <[email protected]> wrote in message
> news:[email protected]...
> > Sorry, Aaron, I guess I wasn't clear. I meant to right-click on the
> worksheet
> > name tabs, which brings up a sub-menu. Then you choose your options
> normally
> > by left-clicking.
> >
> > Jennifer is asking about sorting the tabs in the lower left-hand corner of
> > the sheet; that's where you right-click to bring up the sub-menues.
> >
> > "[email protected]" wrote:
> >
> > > Traveller
> > >
> > > sorry but; Excel sucks balls. Only in Access can you right-click SORT
> > > like that.
> > >
> > > -Aaron
> > >
> > >
> > > Traveller wrote:
> > > > Perhaps I'm missing something, but I think all you have to do is
> right-click
> > > > on the name of one sheet, choose "Select all sheets," then right-click
> again
> > > > and choose "Sort" ascending or desending.
> > > >
> > > > "Jennifer" wrote:
> > > >
> > > > > I have a workbook created by someone else with about 50 different
> sheet tabs.
> > > > > Each tab is a part number. I would like to organize them
> alphabetically but
> > > > > it is quite a chore since there are so many. Is there a macro I can
> use that
> > > > > will automatically put them in alphabetical order?
> > > > >
> > > > > Thanks in advance for any help!
> > > > >
> > > > > Jennifer
> > >
> > >

[greaseman]

Aaron,

If you hate Excel so much, why are you wasting your time looking for that functionality?

Are you that stupid? In past postings, you've bragged of how great and smart you are, but now you can't find a sorting functionality?

You're an idiot (to paraphrase what you've called other people in this forum).

[Traveller]

From what you all are writing, I think this feature might be specific to
Excel 2003. My help file gives this instruction for selecting all worksheets:

"Right-click a sheet tab, and then click Select All Sheets on the shortcut
menu (shortcut menu: A menu that shows a list of commands relevant to a
particular item. To display a shortcut menu, right-click an item or press
SHIFT+F10.)."

What I was calling a sub-menu, they call a shortcut menu. On that menu, Sort
Sheets is right above Tab Color. I was wrong about one thing: you don't even
have to Select All Sheets to sort them. Again, perhaps I'm getting this
option from an add-in that I've forgotten about!??


"Traveller" wrote:

> Absolutely. Works great for me (Excel 2003). I don't think I've done anything
> special to my Excel. Maybe I'm still not explaining it very well. I'll check
> the help files and see if I can come up with clearer instructions.
>
> "Gord Dibben" wrote:
>
> > Traveller
> >
> > Did you try your method?
> >
> >
> > Gord Dibben MS Excel MVP
> >
> > On Wed, 9 Aug 2006 10:08:01 -0700, Traveller
> > <[email protected]> wrote:
> >
> > >Perhaps I'm missing something, but I think all you have to do is right-click
> > >on the name of one sheet, choose "Select all sheets," then right-click again
> > >and choose "Sort" ascending or desending.
> > >
> > >"Jennifer" wrote:
> > >
> > >> I have a workbook created by someone else with about 50 different sheet tabs.
> > >> Each tab is a part number. I would like to organize them alphabetically but
> > >> it is quite a chore since there are so many. Is there a macro I can use that
> > >> will automatically put them in alphabetical order?
> > >>
> > >> Thanks in advance for any help!
> > >>
> > >> Jennifer
> >
> >

[Jim Cone]

You wouldn't happen to have "XL Extras" installed? ( tools | add-ins )
Available for free from http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA



"Traveller"
<[email protected]>
wrote in message
From what you all are writing, I think this feature might be specific to
Excel 2003. My help file gives this instruction for selecting all worksheets:

"Right-click a sheet tab, and then click Select All Sheets on the shortcut
menu (shortcut menu: A menu that shows a list of commands relevant to a
particular item. To display a shortcut menu, right-click an item or press
SHIFT+F10.)."

What I was calling a sub-menu, they call a shortcut menu. On that menu, Sort
Sheets is right above Tab Color. I was wrong about one thing: you don't even
have to Select All Sheets to sort them. Again, perhaps I'm getting this
option from an add-in that I've forgotten about!??


"Traveller" wrote:
> Absolutely. Works great for me (Excel 2003). I don't think I've done anything
> special to my Excel. Maybe I'm still not explaining it very well. I'll check
> the help files and see if I can come up with clearer instructions.


>
> "Gord Dibben" wrote:>
> > Traveller> >
> > Did you try your method?
> >
> > Gord Dibben MS Excel MVP

[Gord Dibben]

I would say definitely an add-in.

This feature is not Excel 2003 default.

Thanks for the update. I was thinking I missed something, which is not unheard
of<g>


Gord

On Wed, 9 Aug 2006 11:52:01 -0700, Traveller
<[email protected]> wrote:

>From what you all are writing, I think this feature might be specific to
>Excel 2003. My help file gives this instruction for selecting all worksheets:
>
>"Right-click a sheet tab, and then click Select All Sheets on the shortcut
>menu (shortcut menu: A menu that shows a list of commands relevant to a
>particular item. To display a shortcut menu, right-click an item or press
>SHIFT+F10.)."
>
>What I was calling a sub-menu, they call a shortcut menu. On that menu, Sort
>Sheets is right above Tab Color. I was wrong about one thing: you don't even
>have to Select All Sheets to sort them. Again, perhaps I'm getting this
>option from an add-in that I've forgotten about!??
>
>
>"Traveller" wrote:
>
>> Absolutely. Works great for me (Excel 2003). I don't think I've done anything
>> special to my Excel. Maybe I'm still not explaining it very well. I'll check
>> the help files and see if I can come up with clearer instructions.
>>
>> "Gord Dibben" wrote:
>>
>> > Traveller
>> >
>> > Did you try your method?
>> >
>> >
>> > Gord Dibben MS Excel MVP
>> >
>> > On Wed, 9 Aug 2006 10:08:01 -0700, Traveller
>> > <[email protected]> wrote:
>> >
>> > >Perhaps I'm missing something, but I think all you have to do is right-click
>> > >on the name of one sheet, choose "Select all sheets," then right-click again
>> > >and choose "Sort" ascending or desending.
>> > >
>> > >"Jennifer" wrote:
>> > >
>> > >> I have a workbook created by someone else with about 50 different sheet tabs.
>> > >> Each tab is a part number. I would like to organize them alphabetically but
>> > >> it is quite a chore since there are so many. Is there a macro I can use that
>> > >> will automatically put them in alphabetical order?
>> > >>
>> > >> Thanks in advance for any help!
>> > >>
>> > >> Jennifer
>> >
>> >

[[email protected]]

greaseman

some excel dork was saying it was easy to alphabetize sheet names.

I wish that it was easy. That is one thing that I would have liked to
use; back in the stone age when I gave a crap about Excel.

In general; sorting and filtering in Access consists of right-click
sort and right-click filter.
it also supports much more powerful sorting and filtering through the
use of queries, views, sprocs.

Excel is for babies.. and I was correcting some mis-information.

-Aaron


greaseman wrote:
> Aaron,
>
> If you hate Excel so much, why are you wasting your time looking for
> that functionality?
>
> Are you that stupid? In past postings, you've bragged of how great and
> smart you are, but now you can't find a sorting functionality?
>
> You're an idiot (to paraphrase what you've called other people in this
> forum).
>
>
> --
> greaseman
> ------------------------------------------------------------------------
> greaseman's Profile: http://www.excelforum.com/member.php...o&userid=28808
> View this thread: http://www.excelforum.com/showthread...hreadid=569852

[Traveller]

I checked and I sure do (at my age I can barely remember my name, let alone
the specifics of an add-in that I had forgotten about and had apparently been
taking for granted). If that is the source of my sorting power (together with
your Special Sort program, which I haven't forgotten about and which I
consider the best $14 I ever spent) then lets give credit where credit is
due.

By the way, I also highly recommend the free ASAP add-in, with something
like 300 features, some of which I couldn't live without.

So I apologize to everyone who wondered if one of us wasn't going crazy and
I give credit to Jim Cone for his great programming.


"Jim Cone" wrote:

> You wouldn't happen to have "XL Extras" installed? ( tools | add-ins )
> Available for free from http://www.realezsites.com/bus/primitivesoftware
> No registration required.
> --
> Jim Cone
> San Francisco, USA
>
>
>
> "Traveller"
> <[email protected]>
> wrote in message
> From what you all are writing, I think this feature might be specific to
> Excel 2003. My help file gives this instruction for selecting all worksheets:
>
> "Right-click a sheet tab, and then click Select All Sheets on the shortcut
> menu (shortcut menu: A menu that shows a list of commands relevant to a
> particular item. To display a shortcut menu, right-click an item or press
> SHIFT+F10.)."
>
> What I was calling a sub-menu, they call a shortcut menu. On that menu, Sort
> Sheets is right above Tab Color. I was wrong about one thing: you don't even
> have to Select All Sheets to sort them. Again, perhaps I'm getting this
> option from an add-in that I've forgotten about!??
>
>
> "Traveller" wrote:
> > Absolutely. Works great for me (Excel 2003). I don't think I've done anything
> > special to my Excel. Maybe I'm still not explaining it very well. I'll check
> > the help files and see if I can come up with clearer instructions.
>
>
> >
> > "Gord Dibben" wrote:>
> > > Traveller> >
> > > Did you try your method?
> > >
> > > Gord Dibben MS Excel MVP
>
>

[Bob Phillips]

Nah, we all knew it was you going crazy <vbg>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Traveller" <[email protected]> wrote in message
news:[email protected]...
> I checked and I sure do (at my age I can barely remember my name, let
alone
> the specifics of an add-in that I had forgotten about and had apparently
been
> taking for granted). If that is the source of my sorting power (together
with
> your Special Sort program, which I haven't forgotten about and which I
> consider the best $14 I ever spent) then lets give credit where credit is
> due.
>
> By the way, I also highly recommend the free ASAP add-in, with something
> like 300 features, some of which I couldn't live without.
>
> So I apologize to everyone who wondered if one of us wasn't going crazy
and
> I give credit to Jim Cone for his great programming.
>
>
> "Jim Cone" wrote:
>
> > You wouldn't happen to have "XL Extras" installed? ( tools | add-ins )
> > Available for free from
http://www.realezsites.com/bus/primitivesoftware
> > No registration required.
> > --
> > Jim Cone
> > San Francisco, USA
> >
> >
> >
> > "Traveller"
> > <[email protected]>
> > wrote in message
> > From what you all are writing, I think this feature might be specific to
> > Excel 2003. My help file gives this instruction for selecting all
worksheets:
> >
> > "Right-click a sheet tab, and then click Select All Sheets on the
shortcut
> > menu (shortcut menu: A menu that shows a list of commands relevant to a
> > particular item. To display a shortcut menu, right-click an item or
press
> > SHIFT+F10.)."
> >
> > What I was calling a sub-menu, they call a shortcut menu. On that menu,
Sort
> > Sheets is right above Tab Color. I was wrong about one thing: you don't
even
> > have to Select All Sheets to sort them. Again, perhaps I'm getting this
> > option from an add-in that I've forgotten about!??
> >
> >
> > "Traveller" wrote:
> > > Absolutely. Works great for me (Excel 2003). I don't think I've done
anything
> > > special to my Excel. Maybe I'm still not explaining it very well. I'll
check
> > > the help files and see if I can come up with clearer instructions.
> >
> >
> > >
> > > "Gord Dibben" wrote:>
> > > > Traveller> >
> > > > Did you try your method?
> > > >
> > > > Gord Dibben MS Excel MVP
> >
> >

[[email protected]]

greaseman

for the record-- I was correcting mis-information.

home-slice was saying you could right-click sort on the sheetnames and
sort them alphabetically.

CAN YOU DO THIS?

Eat **** greaser; I'm just making sure that people are aware that there
ARE better tools on the market.

TOO MANY CHIEFS AND NOT ENOUGH INDIANS.

-Aaron




greaseman wrote:
> Aaron,
>
> If you hate Excel so much, why are you wasting your time looking for
> that functionality?
>
> Are you that stupid? In past postings, you've bragged of how great and
> smart you are, but now you can't find a sorting functionality?
>
> You're an idiot (to paraphrase what you've called other people in this
> forum).
>
>
> --
> greaseman
> ------------------------------------------------------------------------
> greaseman's Profile: http://www.excelforum.com/member.php...o&userid=28808
> View this thread: http://www.excelforum.com/showthread...hreadid=569852

[[email protected]]

yeah I'm just glad that greaseman didn't get all up on my back all over
nothing.

sounds like a great tool.

I just wish that MS would give this functionality.

I've been asking for MS to give us the ability to SORT FIELDNAMES --
like in a database-- alphabetically or in a query; and they apparently
don't think that it's important.

-Aaron



Gord Dibben wrote:
> I would say definitely an add-in.
>
> This feature is not Excel 2003 default.
>
> Thanks for the update. I was thinking I missed something, which is not unheard
> of<g>
>
>
> Gord
>
> On Wed, 9 Aug 2006 11:52:01 -0700, Traveller
> <[email protected]> wrote:
>
> >From what you all are writing, I think this feature might be specific to
> >Excel 2003. My help file gives this instruction for selecting all worksheets:
> >
> >"Right-click a sheet tab, and then click Select All Sheets on the shortcut
> >menu (shortcut menu: A menu that shows a list of commands relevant to a
> >particular item. To display a shortcut menu, right-click an item or press
> >SHIFT+F10.)."
> >
> >What I was calling a sub-menu, they call a shortcut menu. On that menu, Sort
> >Sheets is right above Tab Color. I was wrong about one thing: you don't even
> >have to Select All Sheets to sort them. Again, perhaps I'm getting this
> >option from an add-in that I've forgotten about!??
> >
> >
> >"Traveller" wrote:
> >
> >> Absolutely. Works great for me (Excel 2003). I don't think I've done anything
> >> special to my Excel. Maybe I'm still not explaining it very well. I'll check
> >> the help files and see if I can come up with clearer instructions.
> >>
> >> "Gord Dibben" wrote:
> >>
> >> > Traveller
> >> >
> >> > Did you try your method?
> >> >
> >> >
> >> > Gord Dibben MS Excel MVP
> >> >
> >> > On Wed, 9 Aug 2006 10:08:01 -0700, Traveller
> >> > <[email protected]> wrote:
> >> >
> >> > >Perhaps I'm missing something, but I think all you have to do is right-click
> >> > >on the name of one sheet, choose "Select all sheets," then right-click again
> >> > >and choose "Sort" ascending or desending.
> >> > >
> >> > >"Jennifer" wrote:
> >> > >
> >> > >> I have a workbook created by someone else with about 50 different sheet tabs.
> >> > >> Each tab is a part number. I would like to organize them alphabetically but
> >> > >> it is quite a chore since there are so many. Is there a macro I can use that
> >> > >> will automatically put them in alphabetical order?
> >> > >>
> >> > >> Thanks in advance for any help!
> >> > >>
> >> > >> Jennifer
> >> >
> >> >

[[email protected]]

and I've NEVER bragged about how great and smart I am.

I brag about how great SQL Server is.

For starters, it can use this little invention called MEMORY--
something that Excel can't utilize.

-Aaron



greaseman wrote:
> Aaron,
>
> If you hate Excel so much, why are you wasting your time looking for
> that functionality?
>
> Are you that stupid? In past postings, you've bragged of how great and
> smart you are, but now you can't find a sorting functionality?
>
> You're an idiot (to paraphrase what you've called other people in this
> forum).
>
>
> --
> greaseman
> ------------------------------------------------------------------------
> greaseman's Profile: http://www.excelforum.com/member.php...o&userid=28808
> View this thread: http://www.excelforum.com/showthread...hreadid=569852

[greaseman]

Aaron,

You still did not answer my original question: "If you hate Excel so much, why are you wasting your time looking for that functionality?"

Three responses from you and you didn't answer the question, which is par for the course when it comes to you.

And your original reply to this thread did not "correct mis-information": "I dont see that functionality either." TELL ME HOW YOUR ORIGINAL REPLY CORRECTED ANYTHING, you clown!!

Before telling me to "Eat sh--, greaser", look at your stupid postings and review what you originally say.

(1) Since you are so far removed from Excel, I still don't understand why you'd be looking for anything in Excel.
(2) What mis-information were you trying to correct?

Personally, I think it is YOU who is eating sh--, because you are truly full of crap.