+ Reply to Thread
Results 1 to 9 of 9

Macro to insert "Total" name for each territory

  1. 10-30-2015, 12:00 PM #1
    toci is offline
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Macro to insert "Total" name for each territory

    I have data like in Column A an B. I need a macro which will insert new row after each territory and does =SUM for that territory.
    I need to get data like in Column D and E.

    Some suggestions?

    Thank you in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-30-2015, 12:20 PM #2
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Macro to insert "Total" name for each territory

    Try this:

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.
    Reply With QuoteRegister To Reply
  3. 10-30-2015, 01:04 PM #3
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2409
    Posts
    2,789

    Re: Macro to insert "Total" name for each territory

    Here's my attempt. 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by skywriter; 10-30-2015 at 01:11 PM.
    Reply With QuoteRegister To Reply
  4. 10-30-2015, 02:14 PM #4
    toci is offline
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Re: Macro to insert "Total" name for each territory

    Maybe, I was wrong a little bit in explanation. I need data in Column A and B, Column D and E I've put just to show how it should be. Therefore, I need to insert that rows in column A and B, and if it's possible to be a bold.
    Thank you very much.

    The first one Macro works excellent, I just need only to be a BOLD :D
    Last edited by toci; 10-30-2015 at 02:19 PM.
    Reply With QuoteRegister To Reply
  5. 10-30-2015, 02:18 PM #5
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to insert "Total" name for each territory

    Another:

    Please Login or Register  to view this content.
    Last edited by JOHN H. DAVIS; 10-30-2015 at 02:22 PM.
    Reply With QuoteRegister To Reply
  6. 10-30-2015, 02:24 PM #6
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Macro to insert "Total" name for each territory

    Adjusted to include newly requested bolding:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 10-30-2015, 02:32 PM #7
    toci is offline
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Re: Macro to insert "Total" name for each territory

    Thank you guys. Appreciate your efforts!
    Reply With QuoteRegister To Reply
  8. 10-30-2015, 02:34 PM #8
    toci is offline
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Re: Macro to insert "Total" name for each territory

    Sorry, just one more step for code, please :D

    I need Thick Bottom Border for Total.
    Reply With QuoteRegister To Reply
  9. 10-30-2015, 02:55 PM #9
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to insert "Total" name for each territory

    Borders added.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. Insert a value in Column "C" based on the Total in Column "A"
    By Matthew_12345 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-12-2011, 09:08 PM
  3. [SOLVED] Macro to delete entire row if cell contains the word "total" or "Total"
    By theatricalveggie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2011, 12:38 PM
  4. Macro Error with code "Range("A65536").End(xlUp).EntireRow.Insert"
    By lukasj13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2010, 08:48 PM
  5. Insert "Total" each time cell value changes
    By inky in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-02-2008, 07:07 AM
  6. How HardDisk neme "N" or "?" (as cell value) insert into macro formula?
    By frenic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2008, 08:40 AM
  7. [SOLVED] Linking two "total" pages to create a "Complete Total" page
    By Jordon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2006, 07:20 PM
  8. Insert "-" in text "1234567890" to have a output like this"123-456-7890"
    By Alwyn in forum Excel General
    Replies: 3
    Last Post: 10-25-2005, 07:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1