View Single Post
  #1   Report Post  
KReese
 
Posts: n/a
Default Insert a new worksheet after subtotal

Excel 2003

* Importing data from Access to Excel

I have several rows of data relating to geographic regions. The data has
subtotals for each of the regions. Is there a way to get Excel to 'break' to
a new worksheet after each subtotal?
For example, once the North data is subtotaled - I want the South data to
begin on the next worksheet (and so on).

Thanks in advance