View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gayle C[_2_] Gayle C[_2_] is offline
external usenet poster
 
Posts: 6
Default Move - update - sort descending

I have a worksheet that updates from another worksheet. I need the second
worksheet to automatically sort in descending order.

Example:
Cols A-B-C-D updates Cols F-G-H-I

A B C D updates F G H
I
name Date Gm Score name date GM Score
Tm 1 1-07 Gm1 200 Tm 1 1-14 Gm2 500
Tm 1 1-07 Gm2 150 Tm 1 1-14 Gm1 300
Tm 1 1-14 GM1 300 Tm 1 1-07 Gm1 200
Tm 1 1-14 GM2 500 Tm 1 1-07 Gm2 150

Once data is updated, I need it to sort in descending order automatically.

Thanks for any assistance in resolving this.