Autorun Macro to auto filter on cell value change

[jjm.delta]

Hi all,
I have a small problem. I have a workbook with 2 sheets - Models and Details. I would like to have a macro to autorun and autofilter Model worksheet by column A each time I input any value in Details worksheet. I attach a sample workbook as the code I have is not working. Can anybody assist please? Much appreciate any assistance.
Thanks to all.
JJM

[NGUIMARAES]

I propose the creation of a table pivotable (Tab2), on new sheet (Teste), and a procedure for updating the sheet "Teste", each time a change is made in sheet (Details).


About the procedure I wrote:

Private Sub Worksheet_Change(ByVal Target As Range)
Sheets("Teste").PivotTables("Tab2").RefreshTable
End Sub


I’m sending an attached example, I hope to help.



AUTORUN AUTOFILTER MACRO.xlsm