+ Reply to Thread
Results 1 to 2 of 2

Copying the totals from a sub-total worksheet to new worksheet without the underlying data

  1. #1
    Registered User
    Join Date
    01-02-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Copying the totals from a sub-total worksheet to new worksheet without the underlying data

    I have listed all the month's transactions in three columns, date customer and amount.
    I have sorted the month's list by customer and sub-totalled it getting the usual "1 2 and 3" choices at the top left of the sub-total page.
    I now have 12 of these( one for each month)
    I wish to copy the customer totals (No. 2 of the "1 2 and 3") off the sub-total page and on to a new sheet.
    However the copy and paste or cut and paste commands take the totals across with all the underlying items that make up those totals, so that I can't get just the 12 monthly totals for each customer, which is all I want.

    Please can you tell me how I get excel to just copy across the totals without the underlying items?

    Thanks

    Phil

  2. #2
    Forum Contributor
    Join Date
    05-04-2012
    Location
    Stamford,Connecticut,USA
    MS-Off Ver
    Excel 2003
    Posts
    105

    Re: Copying the totals from a sub-total worksheet to new worksheet without the underlying

    Try this:
    Select the Area you want to copy
    then hit the F5 Key then
    click on the Special button, then
    click on the Visible Cells Only radio button then
    click OK
    Then click on Copy
    Then Select the pasting destination
    Then hit paste

+ 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