View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kaywe44 kaywe44 is offline
external usenet poster
 
Posts: 6
Default Can I sort worksheets based on the tab name?

I'm on Microsoft Office 2003. Is it possible to sort worksheets
alphabetically or numberically or any other way? For example, I want to have
a different sheet for each person I am setting up. Their last name & 1st
initial make up the name on the tab. I have 100+ names, & they are randomly
set up, not in any order. After I finish, can I sort the worksheets
alphabetically so that the tabs will be lined up by the person's last name?
Thanks!