Marco to print row if Cell A4 = what is in Column B

[Daved]

I have 2000 rows of data and need to print the rows that have a match between A4 and what is in column B… I appreciate any help you can give..

 

[Joe C]

Did you try using the filter?

 

[Daved]

Filter? I can do it without the macro but need one because these files are updated weekly and I need the flexibility of a macro.

 

[Joe C]

Below code will turn on the filter
and filter by what you want.


sub filter

CA = Cells(1, 4)
Cells.Select
Selection.AutoFilter
Selection.AutoFilter Field:=4, Criteria1:=CA

end sub

 

[Joe C]

Actually field would be 2 sorry.

 

[Daved]

Thank you
This is just what I needed
ray: