VBA - I am nota able to change extract data

[Joselica]

Helo,
I am not abble to modify the VBA.
The VBA from the Sheet1("LISTADO") is filtering the data from the same sheet.
I am not able to modify the macro so that to filter the new data from the "DATA" sheet and not from the sheet "LISTADO".
I attache de workbook.
Thak you.
Sorry for my bad english.
Regards,
Joseph

[davesexcel]

You have
Hoja1.Select which in fact is "LISTADO"

If you wanted to do something in "DATOS" then do not select "Hoja1"

[Joselica]

Dear Dave,

Thank you for your answer.
I have wasted many hours trying to figure this out before asking for help.
I am not a pro with vba.
All times y watch videos befor to start something and I ask for help only when I don't see the errors.
I will spend more hours trying to understand and solve it starting from your observation.
Regards,
Joseph
For