Results 1 to 9 of 9

macro to insert 2 rows on each change in customer name and put a total for all amounts and

Threaded View

  1. 08-22-2022, 03:59 AM #1
    tariqnaz2005
    tariqnaz2005 is offline
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2019
    Posts
    292

    Lightbulb macro to insert 2 rows on each change in customer name and put a total for all amounts and

    Dear all,

    Good day.

    I would be highly appreciated if someone could help me out for a macro to insert 2 rows on each change in customer name and put a total for all amounts and highlight in yellow or any color.

    attached workbook has 2 sheets.. sheet1 is original data.. and sheet2 is my requirements what i want to do. thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Macro - Loop through rows when change total up total row
    By mklindquist815 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-04-2021, 03:22 PM
  2. [SOLVED] Adding 2 rows, total AMOUNTs and add a page break to each subset.
    By DanWand in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-22-2018, 01:11 AM
  3. change macro insert rows -help
    By Kiluk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2017, 07:39 AM
  4. Need help modifying a macro to insert rows after date change.
    By Graham Pall in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-22-2015, 06:31 AM
  5. Grouping rows based on keywords and summing the associated total amounts
    By tvwright in forum Excel General
    Replies: 4
    Last Post: 07-08-2015, 12:05 PM
  6. [SOLVED] Macro to insert blank rows so that the total number of rows with data is equal to 1021
    By nsm1411 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2013, 10:25 AM
  7. macro to Insert rows at every change in a column
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2005, 09:05 AM

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