Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Dec 2001
    Location
    Texas
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy Subtotal Data (Excel 2000)

    Is there any easy way to copy subtotaled data to another worksheet? After subtotaling and choosing level 2, I copy the list and paste it to another worksheet;however, it brings over everything. Any suggestions?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy Subtotal Data (Excel 2000)

    After selecting the list, point to Edit | GoTo..., select the "Visible Cells Only" option, then click OK. Now, you will copy and paste only the visible cells.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Copy Subtotal Data (Excel 2000)

    If you carry out this operation on a regular basis, it could be worth your while to include 2 command buttons on your toolbar.

    Go to Tools, Customize, select the Commands tab and the Edit category. Scroll down to the bottom of the commands available and you should find two buttons, one to select the Current Region and another to Select Visible Cells (see attached). Drag them both to your toolbar. The next time you need to copy a filtered list just select a cell in the list, click the Select Current Region button and then click the Select Visible Cells. You can then copy your selection which will just contain the visible cells from your filtered list.

    Andrew C

  4. #4
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy Subtotal Data (Excel 2000)

    Stephen:

    Following on from Andrew's post, if you prefer keyboard shortcuts, CTRL+* (or CTRL+SHIFT+8) will Select Current Region and ALT+; will Select Visible Cells in the current selection.

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Albuquerque, New Mexico, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy Subtotal Data (Excel 2000)

    I just love Woody's Lounge! Sometimes you pick up a tip that makes your computing life easier and that's just what happened when reviewing today's Daily Archive of Excel! Even after using software for years (like Excel), you don't know all of the tricks or features. That's why I love this place. <img src=/S/love.gif border=0 alt=love width=15 height=15>

Posting Permissions

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