I have 4 sheets that are used for sorting data, this data is placed there from a Macro on another sheet, once the data is placed in the sorting sheet, it is activated by opening the sheet, the data is then linked to a results page.

I want to either get the macro to sort with a selection change event or call the macro's from the results sheet when it is opened.

Is it possible to have a selection change function activate a macro when the data is put into a sheet by a macro as I have tried this method without success.

This is the Macro that I am currently using to sort the 4 sheets.

[VBA] rivate Sub Worksheet_Activate()
Range("A2", Range("F65536").End(xlUp).Address).Select
Selection.Sort Key1:=Range("F2"), Order1:=xlAscending _
, Key2:=Range("E2"), Order2:=xlAscending _
, Key3:=Range("D2"), Order3:=xlDescending
Selection.Sort Key1:=Range("B2"), Order1:=xlAscending _
, Key2:=Range("C2"), Order2:=xlAscending _
End Sub
[/VBA]

At the moment I have no code on the results sheet, what I need is some code to either call the macros or a selection change modification to this code.

Thanks for any help.