Copying filtered data from one Worksheet1 and past it to another Worksheet2 and update it.

[Yeft]

Hello There!. Any one who can help me with a code for my request?. Ièm just a begginer with VBA and I'm struggling with it.
The key point is that after pasting the filtered data e.g. filtered by "SALE" . and the Sheet2 should automatically refresh by just selecting the Worksheet tab.
Any help would be greatly appreciated.

 

[dermie_72]

If you add the following code intot he Microsofe Excel Objects Sheet that you want to affect it will show all data when you activate it.

Private Sub Worksheet_Activate()
    If ActiveSheet.AutoFilterMode Then
        ActiveSheet.ShowAllData
    End If
End Sub

 

[Yeft]

Hello Dermie_72

I may have not explain well. I want to capture any filtered data e.g.: "SALE" and copy all respective data, and paste it into the Worksheet2
and any time I check this worksheet , just by clicking on it it should update that filtered data, which is continuously changing.
Would you be able to write the whole Macro?
Thanks