-
Call Macros in other worksheets or selection change event?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules