Quote Originally Posted by JBeaucaire View Post
Yes, macros would be simplest. I'll offer that.

1) Right-click on the FAX tab and select VIEW CODE
2) Paste in this sheet activation macro:
Option Explicit

Private Sub Worksheet_Activate()
    Sheets("Player DATA").Range("B3:B27").Copy
    Range("B5").PasteSpecial xlPasteValues
    Sheets("Player DATA").Range("AL3:AL27").Copy
    Range("C5").PasteSpecial xlPasteValues
    Range("A5:C29").Sort Key1:=Range("A5"), Order1:=xlAscending, Header:=xlNo, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal
End Sub
3) Close the editor
4) Save your sheet as a macro-enabled workbook (*.xlsm)
5) Now each time you bring up the FAX sheet onscreen it will reassert the list in ascending order.
hi,

I have similar problem with this, only that the data source is available in another workbook instead in another worksheet..
how should I modify the code to get the result?

thanks in advance