Thread: Sort
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jimmy Jimmy is offline
external usenet poster
 
Posts: 11
Default Sort

I am creating a copy of a sheet in an outside excel file
and then currently am placing it immediately after the
first (template) sheet. I wanted to know if it was
possible to sort through the different tabs and place the
new sheet in alphabetical order of the rest of the
sheets. the sheet name that is created is (firstname1
lastname1, firstname2) i want to have all the tabs
alphabetically organized off of firstname1. there will be
three different sheets created with the identical
firstname1 lastname1, within these three sheets i want
them to be sorted according to firstname2 (which will be
unique). thanks for any help