+ Reply to Thread
Results 1 to 2 of 2

Insert a new worksheet after subtotal

  1. #1
    KReese
    Guest

    Insert a new worksheet after subtotal

    RE: 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


  2. #2
    Nick Hodge
    Guest

    Re: Insert a new worksheet after subtotal

    You cannot do this using the subtotal functionality (Except a page break for
    printing)

    You could use a pivot table instead and set up each geographic region as a
    page field and then use 'Show Pages' This sets up a new pivot table on a
    new worksheet for each region

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    [email protected]HIS


    "KReese" <[email protected]> wrote in message
    news:[email protected]...
    > RE: 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1