AutoSort col when Cell value changes

[NateD1]

Hello All

In need of some help, i have a table which i would like it to auto sort if a cell value changes.

Header of table is Row: A12:Q12. within this table i would like to sort only header AL12.
cell A3 is the reference cell which will change. If Cell A3 changes value, AL12 to sort table col in Ascending order.
Thank

 

[Fluff]

How is A3 being changed?
Also is your table a structured table & if so what is it's name?

 

[NateD1]

its linked to a pivot which will display Text&Date when using slicers, and not a structured table sorry.

 

[Fluff]

As I no nothing about pivots, unfortunately I cannot help.

 

[NateD1]

its linked to a pivot which will display Text&Date when using slicers, and not a structured table sorry.

As I no nothing about pivots, unfortunately I cannot help.

essentially its just a data set with Filters, and the data is just pulled from the pivots (so pivots dont impact anything). when i change my selection i just need col AL to sort Ascending. if A3 changes. thanks

 

[Fluff]

How is A3 being changed?

 

[NateD1]

How is A3 being changed

its changed automatically when i select from a dropdown to choose a different date period for my data. in Cell A3 its just ="DATE"&""&"TIME"

 

[Fluff]

Is it a formula or data validation ?

 

[NateD1]

Formula

 

[Fluff]

Ok, how about

Private Sub Worksheet_Calculate()
   Range("A12:Q" & Range("A" & Rows.Count).End(xlUp).Row).Sort key1:=Range("A12"), order1:=xlAscending, Header:=xlYes
End Sub

This will trigger whenever any cell recalculates.
I have also assumed it should sort on col A as col AL is not in the data range