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

Sort
 

Use Ron De Bruin's google add in to search for Sort sheets
http://www.rondebruin.nl/


--
Don Guillett
SalesAid Software

"jimmy" wrote in message
...
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

Sort
 

this is for internet searches i am just copying values
from a userform in one excel workbook to another excel
workbook. when the userform is filled out a sheet is
created in the other excel workbook with a new sheet that
is renamed to a field in the userform. I want to be able
to insert the new sheet into the workbook in alphabetical
order. i dont know if this is possible. thanks...


-----Original Message-----
Use Ron De Bruin's google add in to search for Sort sheets
http://www.rondebruin.nl/


--
Don Guillett
SalesAid Software

"jimmy" wrote in
message
...
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


.

Sort
 

Why not just insert and then sort?

--
Don Guillett
SalesAid Software

"jimmy" wrote in message
...
this is for internet searches i am just copying values
from a userform in one excel workbook to another excel
workbook. when the userform is filled out a sheet is
created in the other excel workbook with a new sheet that
is renamed to a field in the userform. I want to be able
to insert the new sheet into the workbook in alphabetical
order. i dont know if this is possible. thanks...


-----Original Message-----
Use Ron De Bruin's google add in to search for Sort sheets
http://www.rondebruin.nl/


--
Don Guillett
SalesAid Software

"jimmy" wrote in
message
...
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


.

Sort
 

i am not sure how to write the sort algorithm.. I have
very limited vb knowledge and am unsure how to do an
alphabetical sort...if you could help it would be great.
thanks


-----Original Message-----
Why not just insert and then sort?

--
Don Guillett
SalesAid Software

"jimmy" wrote in
message
...
this is for internet searches i am just copying values
from a userform in one excel workbook to another excel
workbook. when the userform is filled out a sheet is
created in the other excel workbook with a new sheet
that
is renamed to a field in the userform. I want to be
able
to insert the new sheet into the workbook in
alphabetical
order. i dont know if this is possible. thanks...


-----Original Message-----
Use Ron De Bruin's google add in to search for Sort
sheets
http://www.rondebruin.nl/


--
Don Guillett
SalesAid Software

"jimmy" wrote in
message
...
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


.



.

Sort
 

You've heard the story about the fish, haven't you?

Use Ron De Bruin's google add in to search for Sort sheets
http://www.rondebruin.nl/

--
Don Guillett
SalesAid Software

"jimmy" wrote in message
...
i am not sure how to write the sort algorithm.. I have
very limited vb knowledge and am unsure how to do an
alphabetical sort...if you could help it would be great.
thanks


-----Original Message-----
Why not just insert and then sort?

--
Don Guillett
SalesAid Software

"jimmy" wrote in
message
...
this is for internet searches i am just copying values
from a userform in one excel workbook to another excel
workbook. when the userform is filled out a sheet is
created in the other excel workbook with a new sheet
that
is renamed to a field in the userform. I want to be
able
to insert the new sheet into the workbook in
alphabetical
order. i dont know if this is possible. thanks...


-----Original Message-----
Use Ron De Bruin's google add in to search for Sort
sheets
http://www.rondebruin.nl/


--
Don Guillett
SalesAid Software

"jimmy" wrote in
message
...
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


.



.