| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
| Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
| sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
| Ascending Sort formula, change to neg #: descending sort.. | Excel Discussion (Misc queries) | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Linear Mode
