Because I want to avoid a copy and paste. I need to automate it just a
little bit. So I have this function

Sub DoReport()
With Worksheets("Master List")
.Range("A2:O2").Copy Destination:=Worksheets("Report").Range("A4")
End With

End Sub

But I would like to modify that so it paste's only values (no formating,
like paste special) and so that it only selects where state = $Report$A1

Peter

Pete_UK wrote:
Why not use Autofilter, then, selecting the State from your State
column? You can highlight the visible cells and copy them to another
sheet quite easily.

Hope this helps.

Pete