Alphabetizing worksheets

[ME]

Hi, I have created numerous balance sheet worksheets
within one workbook for the purpose of keeping track of
individual donors. Nice template...already set up. I
have 300 in, but would like to sort alphabetically. All
I have in is the last name. Help! Is this possible?

Also, if it is not possible, is there a way to find one
worksheet within a workbook by name?
Thanks for your help.

 

[Peo Sjoblom]

See:

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

 

[Gord Dibben]

ME

To sort alphabetically see Chip Pearson's VBA code at......

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

To sort sheets and build a table of contents see David McRitchie's VBA code
at....

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Gord Dibben Excel MVP

 

[Guest]

Thank you for your reply. I wish I was as computer savy
to know where these codes go. Could you please help a
little more? My e-mail address is (e-mail address removed). If
possible, I'd like to send you my form so you would know
what I'm working with.
Thanks so much.

 

[Gord Dibben]

ME

For more on "getting started with macros" see David McRitchie's site.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Send the workbook to me if you wish.

Alter the DOT and AT in my posted address.

Also, posting your real email address is not advisable due to the "harvesters"
covering these News Groups.

Gord