| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy sort order between worksheets
I have two worksheets and each has a unique value in column A but then
different values in other columns. After sorting worksheet 1 in a chosen order, I would like to automate the sorting of worksheet 2 so that the values in column 1 in worksheet 2 appear in the same order as in worksheet 1. Is this possible in VBA Eddie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy sort order between worksheets
Sounds like you could create a custom list using the sorted list from workbook 1. Then use the custom list to sort the column in workbook 2. See "AddCustomList" method in vba help. -- Jim Cone Portland, Oregon USA "Eddie" wrote in message I have two worksheets and each has a unique value in column A but then different values in other columns. After sorting worksheet 1 in a chosen order, I would like to automate the sorting of worksheet 2 so that the values in column 1 in worksheet 2 appear in the same order as in worksheet 1. Is this possible in VBA Eddie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i re-sort multiple worksheets into alphabetical order | Excel Discussion (Misc queries) | |||
| How do I arrange/sort worksheets in ascending order? | Excel Discussion (Misc queries) | |||
| Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
| sort worksheets in numerical order | Excel Discussion (Misc queries) | |||
| I want to sort worksheets in a workbook into Alpha order? | Excel Worksheet Functions | |||
Hybrid Mode
