copy sort order between worksheets

  • Thread starter Thread starter Eddie
  • Start date Start date
E

Eddie

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
 
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"
<[email protected]>
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem sorting a range of columns using VBA 1
[Q] How to sort tabs in order of CodeName 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel 2013 Merge Data 2
fill in data that is not empty 1
Ron de Bruin - Merge cells from all worksheets 0
Excel VBA 1
Pictures not being sorted in VBA 2

Back
Top