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