Check this page on the Contextures site:

http://www.contextures.com/excelfiles.html

In the Filters section there are several sample workbooks which use macros
to execute the advanced filter to copy records from a master sheet to
individual sheets. For example:

Create New Sheets from List -- uses an Advanced Filter to create separate
sheet of orders for each sales rep; macro automates the filter.
AdvFilterRep.zip

I think you find something there you can adapt. Let me know (via reply to
this thread) if you need help.

Hope this helps,

Hutch

"Valerie" wrote:

Hello!

I create a sales stack ranking for a sales force that has a main page with
everyones numbers across the nation. I also have a worksheet that has each
sales persons numbers broken out by region.

I want to know of a way to have a worksheet for florida read the main stack
ranking page and pull lines of data that have "florida" in column g. Is there
a way to do this?

Right now I am making 10 copies of the main page, for 10 different regions,
and then deleting the information on each WS that isn't for the specific
region. This is really time consuming!

Anyone know how to do this?