View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eddie Eddie is offline
external usenet poster
 
Posts: 30
Default 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