Create Multiple Worksheets based on Market

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to sort data into a new worksheet 1
Stock Market Challenge 7
template creates invoice - how to create summary worksheet? 13
How to save an entireworkbook to individual text files? 3
Netwrokdays in VBA 1
Netwrokdays in VBA 5
Multiple Worksheets 6
replace all formulas with values in multiple worksheets 5

Back
Top