Filter data from one sheet to another

[Reyzenamv]

Hello Everyone!

I need help filtering data from one sheet to another using macros and advanced filtering. I am new using macros, and I would really aprecciate if you could help me.
The idea goes as follow:
I got a worksheet called "Promos" that contains a table full of data. I got another worksheet called "Resume ". The idea would be filtering the data from a list located in Resume, and just pressing a botton to update the filter in PROMOS.

Let me know if you need more information to undestand the situation.

Thank you very much!!

Additional info: I attach a small example, I would like to select a name and FY in the list located in Resume, but I dont want the data to be pasted in Resume I just want the original table in the sheet Promos to be updated.

This is what I have been trying to do with the recorder.
Sub Macro1()
'
' Macro1 Macro
'

'
Application.CutCopyMode = False
Application.CutCopyMode = False
Application.CutCopyMode = False
Application.CutCopyMode = False
Range("E3:AB1523").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Sheets("Resumen Q2 FY20").Range("O4:O5"), Unique:=False
ActiveWindow.SmallScroll Down:=-367
End Sub

The problem with this macro is that it filters the data in the sheet Resume and not the sheet with the original table.

[maniacb]

Please share a sample file as per the yellow banner above so we can see how to help.

[Reyzenamv]

I just uploaded a small example, let me know if you need more information.

Thanks!