Filter rows base on the list

[zzblitzz]

H
I thank you for helping me with this. the situation is on the 1st sheet contains several numbers lined up in column A, this number represents the row number on sheet 2 ( sheet 2 contains the data)

I there a way in macro or ay means that I can filter sheet 2 that only shows whats is being filtered in sheet 1

ex in sheet 1 column A, it s 2,4,5,7,9
then in sheet two it is filtered and only shows row 2,4,5,7,9?

 

[Akuini]

H
I thank you for helping me with this. the situation is on the 1st sheet contains several numbers lined up in column A, this number represents the row number on sheet 2 ( sheet 2 contains the data)

I there a way in macro or ay means that I can filter sheet 2 that only shows whats is being filtered in sheet 1

ex in sheet 1 column A, it s 2,4,5,7,9
then in sheet two it is filtered and only shows row 2,4,5,7,9?

Try this:

Sub a1077373a()
Dim r As Range
    With Sheets("Sheet2")
    .Range("A2", .Cells(Rows.count, "A").End(xlUp)).Rows.Hidden = True
    
        For Each r In Sheets("Sheet1").Range("A2", Sheets("Sheet1").Cells(Rows.count, "A").End(xlUp))
            If IsNumeric(r) Then .Rows(r).Hidden = False
        Next
    
    End With
End Sub

 

[zzblitzz]

this is great it works thank you so much

 

[Akuini]

this is great it works thank you so much

You're welcome & thanks for replying