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