Create Multiple Worksheets based on Market
 

I have an Excel Spredsheet which lists properties and related data (address,
city, st, Region, MARKET, etc.)

An example of my data might be:
PropertyID, Region, Market, Adress, ST, ZIP, Status

What I need to do is create a seperate tab or worksheet for each Market, of
which there are over 20 per Region.

I need to create a seperate workbook for each region. Each workbook would
have a worksheet for each Market.

This is a task that we will be doing frequently (at lesat 1x per week)
Besides the obvious cut/paste method, are there any suggestions on
automating this process? The original data is stored in MS Access, so if
there are any hints involving MS Access I am willing to use them as well.

Thanks in Advance

Create Multiple Worksheets based on Market
 

See this page Scott
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Scott Campbell" <Scott wrote in message
...
I have an Excel Spredsheet which lists properties and related data (address,
city, st, Region, MARKET, etc.)

An example of my data might be:
PropertyID, Region, Market, Adress, ST, ZIP, Status

What I need to do is create a seperate tab or worksheet for each Market, of
which there are over 20 per Region.

I need to create a seperate workbook for each region. Each workbook would
have a worksheet for each Market.

This is a task that we will be doing frequently (at lesat 1x per week)
Besides the obvious cut/paste method, are there any suggestions on
automating this process? The original data is stored in MS Access, so if
there are any hints involving MS Access I am willing to use them as well.

Thanks in Advance