+ Reply to Thread
Results 1 to 10 of 10

How to Insert New Group in Subtoal Group

  1. #1
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

    How to Insert New Group in Subtoal Group

    Dear All,

    Attached herewith the Excel file with self explanatory, i want to add 2012 rows after 2011 group total and then subtotal for 2012 and grand total will add the 2012 total also.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: How to Insert New Group in Subtoal Group

    Is this something that has to reoccur many times? Or just once?

    If it is a one time thing, then follow these steps;

    1. Select A17:F17.
    2. Drag it down to A25:F25.
    3. Select A20:F25.
    4. Drag it up to A17:F22.
    5. Copy A16:F16.
    6. Paste it at A21:F21.
    7. Modify rows 21 & 22 for proper format, text and formulas.

  3. #3
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How to Insert New Group in Subtoal Group

    Hi koolguys4u
    In your actual file, is the 2012 table on the same worksheet? Should we assume there will be many more than 4 rows of data?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: How to Insert New Group in Subtoal Group

    yes sir,
    i have more than 4 rows in year arount 100 rows in each year i have given some rows for understanding, can you give me the sample file with explain.

    I tried the above but it not dragging can you attach the file with picture for understanding clearlry.
    Last edited by koolguys4u; 03-21-2012 at 12:26 PM.

  5. #5
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How to Insert New Group in Subtoal Group

    Hi koolguys4u
    In your actual file, is the 2012 table on the same worksheet as the Summary Data?
    Last edited by jaslake; 03-21-2012 at 12:23 PM.

  6. #6
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: How to Insert New Group in Subtoal Group

    No,

    It is on the other worksheet sheet2 but i want to updata on the sheet1 and there are many more rows in each year i given only few for sample purpose only.

  7. #7
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How to Insert New Group in Subtoal Group

    Hi koolguys4u
    This code assumes 2012 Data is in Sheet2 (with no headers). Let me know of issues.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: How to Insert New Group in Subtoal Group

    Dear Sir,

    It is working but it is not showing as group for 2012 like +/- button to expand or group.

    I need with formula not with macro as macros are disabled in my systme by the administrator. Please help

  9. #9
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: How to Insert New Group in Subtoal Group

    Hi koolguys4u
    I believe you've posted your Thread in the wrong Forum...this is the Excel Programming Forum. You probably should ask a Moderator to move to the Excel General Forum.
    I need with formula not with macro as macros are disabled in my systme by the administrator

  10. #10
    Registered User
    Join Date
    06-07-2009
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: How to Insert New Group in Subtoal Group

    Pleao move my request to General Forum and reply me please

+ 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