+ Reply to Thread
Results 1 to 9 of 9

need subtotal to also include the matching data in subtotal line

  1. #1
    Registered User
    Join Date
    10-01-2014
    Location
    Tx
    MS-Off Ver
    2013
    Posts
    50

    need subtotal to also include the matching data in subtotal line

    I would like my subtotal row to also include the other matchig data. Right now to get the results I want on my spreadsheet this is my process(I know there has to be an easier way):
    subtotal at any change in column b add total to column f
    then I copy and paste special values and number format to another spreadsheet
    go to new sheet insert cell into column a,c,d,ande so that the other data will be in the same row as the subtotal
    finally I delete all data without total in column b.
    and delete the first sheet I did subtotals on.

    I am writing a macro and would like an easier way to do this task.

    Because I know I am terrible at explaining things I have attached worksheet. Sheet 1 is starting data sheet 2 is what I want after subtotal.example.xlsx

    Any help would be greatly appreciated!
    Last edited by baby_kay_2003; 10-11-2014 at 01:47 PM. Reason: Add worksheet
    baby_kay_2003

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: need subtotal to also include the matching data in subtotal line

    Sometimes, when you copy/paste data here, it doesnt always come out the way you planned Can you upload a small sample WB to the forum please, and show what you are working with and what you want?
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-01-2014
    Location
    Tx
    MS-Off Ver
    2013
    Posts
    50

    Re: need subtotal to also include the matching data in subtotal line

    I have added worksheet. Thank you for letting me know.

  4. #4
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    Re: need subtotal to also include the matching data in subtotal line

    Under Menu; Data is a button to add Subtotals. Is that close enough? - It's not exactly what you attached.
    It's also possible to Google for... Excel Subtotal ... and look for Videos.
    //Ola
    Mark the problem as Solved under the Yellow bar up Top right, under Thread Tools, when you received a solution.
    It saves time, to skip already solved threads.

  5. #5
    Registered User
    Join Date
    10-01-2014
    Location
    Tx
    MS-Off Ver
    2013
    Posts
    50

    Re: need subtotal to also include the matching data in subtotal line

    I have Google and can not find what I'm looking for as a end result I am using data subtotal right now but it does not include the other cells on the total row. I have to copy and past the subtotal row that includes all data into another soreadsheet. I just need it to keep every cell and add the total.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: need subtotal to also include the matching data in subtotal line

    I got this, using the built-in SubTotal function....
    A
    B
    C
    D
    E
    F
    1
    Tech ID Activity ID Order Sub Type Account Number Activity Date Payment
    2
    DVIA879701 1-1QF2GOGM Upgrade
    "000000"
    9/23/2014 11:55 AM
    3
    DVIA879701 1-1QF2GOGM Upgrade
    "000000"
    9/23/2014 11:55 AM
    4
    DVIA879701 1-1QF2GOGM Upgrade
    "000000"
    9/23/2014 11:55 AM
    $ 10.00
    5
    DVIA879701 1-1QF2GOGM Upgrade
    "000000"
    9/23/2014 11:55 AM
    $ 20.00
    6
    1-1QF2GOGM Total
    $ 30.00
    7
    DVIA879701 1-1QGWUCGQ New Install
    "000000"
    9/20/2014 11:34 AM
    8
    DVIA879701 1-1QGWUCGQ New Install
    "000000"
    9/20/2014 11:34 AM
    9
    DVIA879701 1-1QGWUCGQ New Install
    "000000"
    9/20/2014 11:34 AM
    10
    DVIA879701 1-1QGWUCGQ New Install
    "000000"
    9/20/2014 11:34 AM
    $ 15.00
    11
    DVIA879701 1-1QGWUCGQ New Install
    "000000"
    9/20/2014 11:34 AM
    $ 15.00
    12
    DVIA879701 1-1QGWUCGQ New Install
    "000000"
    9/20/2014 11:34 AM
    $ 15.00
    13
    DVIA879701 1-1QGWUCGQ New Install
    "000000"
    9/20/2014 11:34 AM
    $ 15.00
    14
    DVIA879701 1-1QGWUCGQ New Install
    "000000"
    9/20/2014 11:34 AM
    $ 65.00
    15
    1-1QGWUCGQ Total
    $ 125.00
    16
    Grand Total
    $ 155.00


    Data Tab/Outline/Subtotal - For Each Change in...Activity ID

  7. #7
    Registered User
    Join Date
    10-01-2014
    Location
    Tx
    MS-Off Ver
    2013
    Posts
    50

    Re: need subtotal to also include the matching data in subtotal line

    That is what I get as well but I need the empty cells to include the other data on the subtotal row. Without having to move data down and delete all rows without the word total in column b.

  8. #8
    Registered User
    Join Date
    10-01-2014
    Location
    Tx
    MS-Off Ver
    2013
    Posts
    50

    Re: need subtotal to also include the matching data in subtotal line

    Does anyone know if this is possible?

  9. #9
    Registered User
    Join Date
    10-01-2014
    Location
    Tx
    MS-Off Ver
    2013
    Posts
    50

    Re: need subtotal to also include the matching data in subtotal line

    Last try because I am desperate...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] subtotal data and include other info from row
    By acp in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-28-2013, 02:57 PM
  2. Automatically copying data to subtotal line
    By tmarcyan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2012, 06:51 PM
  3. Subtotal - Delete zero Subtotal and prior rows that calculate to that zero Subtotal
    By Whatsherface in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2012, 08:37 PM
  4. printing subtotal line with detail data
    By dhubcare in forum Excel General
    Replies: 1
    Last Post: 11-18-2007, 10:10 AM
  5. [SOLVED] subtotal-isplaying data without using function subtotal ?
    By Marijan Glavaè in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2005, 09:05 AM

Tags for this Thread

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