Searching and arranging sheets alphabetically

**nguyeda** · 02-25-2009, 04:22 AM

Hi, I want to make a workbook comprised of many stock symbols... I have about 50 now. Its getting pretty tough to manually put them in alphabetical order, is there any easy way to do this?

How about just search sheets? Can I create a search box that allows me to type in "GM" then it goes to my sheet called "GM"?

**sweep** · 02-25-2009, 04:28 AM

Hi,

This code (from cpearson.com i think) will arrange your sheets alphabetically.

Please Login or Register  to view this content.

**nguyeda** · 02-25-2009, 04:45 AM

Thanks! That was amazing to watch! I'm new at this... sorry.

**sweep** · 02-25-2009, 04:57 AM

That code will arrange your sheets alphabetically. To search go to a specific sheet, use this

Please Login or Register  to view this content.

To enter a macro, use ALT & F11 to open the vba editor
Insert > Module
Paste the code into the window that pops up.
Close the VBA editor

Run the macro from the menus in excel.