VBA Code to filter copied values

[rakesh_baliya]

Hi,

I want to filter data in workbook2 based on the value in workbook1.

i have written macro which will pick values in workbook1 and go to next workbook but I'm not sure about the code to filter the values in workbook2, copied from 1st workbook.

i have written the code as
Sub Copy_Data()
Worksheets(ActiveSheet.Index + 2).Select
Range("A2").Copy


Workbooks("Current_Month_Data.xlsx").Sheets("Sheet1").Activate




End Sub


can anyone please help.