software

Can I sort worksheets in excel by names on tabs?

You would need a macro for that

www.cpearson.com/excel/sortws.htm--

Regards,

Peo Sjoblom

quot;Jimmyquot; gt; wrote in message
...
gt; Can I sort worksheets in excel by names on tabs?
Do I enter the quot;VBA codequot; as a formula?

quot;Peo Sjoblomquot; wrote:

gt; You would need a macro for that
gt;
gt; www.cpearson.com/excel/sortws.htm
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;Jimmyquot; gt; wrote in message
gt; ...
gt; gt; Can I sort worksheets in excel by names on tabs?
gt;
gt;
gt;

If you check the index on Chip's website, there are instructions on where to
place the code and how to use it. Look under VBA and or macrosquot;Jimmyquot; wrote:

gt; Do I enter the quot;VBA codequot; as a formula?
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; You would need a macro for that
gt; gt;
gt; gt; www.cpearson.com/excel/sortws.htm
gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; quot;Jimmyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Can I sort worksheets in excel by names on tabs?
gt; gt;
gt; gt;
gt; gt;

Chip's website being

www.cpearson.com/

quot;Jimmyquot; wrote:

gt; Do I enter the quot;VBA codequot; as a formula?
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; You would need a macro for that
gt; gt;
gt; gt; www.cpearson.com/excel/sortws.htm
gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; quot;Jimmyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Can I sort worksheets in excel by names on tabs?
gt; gt;
gt; gt;
gt; gt;

Jimmy,

Press ALT F11 to open the VBA Editor. There, go to the Insert
menu and choose Module. In that code module, paste the code from
my web site. Go back to Excel, press ALT F8 to bring up the
Macros dialog, and choose SortWS from the list.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Jimmyquot; gt; wrote in message
...
gt; Do I enter the quot;VBA codequot; as a formula?
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; You would need a macro for that
gt;gt;
gt;gt; www.cpearson.com/excel/sortws.htm
gt;gt;
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; quot;Jimmyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Can I sort worksheets in excel by names on tabs?
gt;gt;
gt;gt;
gt;gt;
Jimmy,

Download my free Excel add-in quot;Excel Extrasquot; to sort sheets,
insert a Table of Contents and others.
Comes with an install/use Word file...
www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USAquot;Jimmyquot; gt;
wrote in message
...
Can I sort worksheets in excel by names on tabs?