So I used this method posted about 6 months ago to create a triggered macro to sort a table that updates based on queried data and new calculations.
It was working fine this morning, I came back from lunch and it is now broken.
I changed nothing at all but it will not sort now when the data changes in the table. Can anyone help with this please. below is my macro trigger, The macros themself will run and perform the desired sort when triggered manually, but do not auto sort the table when the ranking changes now.
There are two tables with dynamic data tied to a larger data table the queries a cube on our server and a few other reports that overwrite to a static location. Why will this no longer trigger the appropriate macros to run when the data in the tables chagne?
It was working fine this morning, I came back from lunch and it is now broken.
I changed nothing at all but it will not sort now when the data changes in the table. Can anyone help with this please. below is my macro trigger, The macros themself will run and perform the desired sort when triggered manually, but do not auto sort the table when the ranking changes now.
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("Site_DB")) Is Nothing Then
Macro3
End If
If Not Intersect(Target, Range("Team_DB")) Is Nothing Then
Macro1
End If
End Sub
There are two tables with dynamic data tied to a larger data table the queries a cube on our server and a few other reports that overwrite to a static location. Why will this no longer trigger the appropriate macros to run when the data in the tables chagne?