Hi Sandy,

Consider using Excel's Advanced Filter option, selecting the 'Copy to
another location option. Note that if data is to be copied to another sheet,
the filter should be run from the destination sheet.

If you need to automate the process, turn on the macro recorder while you
perform the required steps. The resultant code may be edited to enable more
general application.

If you experience problems with such editing, post back with the problematic
code.


---
Regards,
Norman


"Sandybam" wrote in message
...
I would like to create a macro that grabs all records with the same State
and
pastes them to a new tab with that State name. Any suggestions would be
great!
Thank you, Sandy