+ Reply to Thread
Results 1 to 3 of 3

Concatenate Column then sum it down

  1. #1
    Registered User
    Join Date
    06-20-2023
    Location
    Jakarta, Indonesia
    MS-Off Ver
    MS OFFICE 2007
    Posts
    29

    Concatenate Column then sum it down

    Hi All,

    how do I create a concatenate macro in column A from column B (code) then based on the code that has been combined, column D to column H, add them up to the bottom.

    I attached an example file
    Attached Files Attached Files
    Last edited by cahayagalax; 09-26-2023 at 04:19 PM. Reason: I posted on the wrong forum. I should have posted on the Forum: Microsoft Office Application Help - Excel Help forum

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Concatenate Column then sum it down

    try
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-20-2023
    Location
    Jakarta, Indonesia
    MS-Off Ver
    MS OFFICE 2007
    Posts
    29

    Re: Concatenate Column then sum it down

    hi jindon,
    I have tried the code, and it works.

    Thank you very much for the macro code.

+ 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] Concatenate Text in Column B Split in Multiple Rows for Each Number in Column A
    By zaska in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2020, 03:51 AM
  2. Concatenate dynamic Column values with column header
    By rockyboy in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-28-2018, 06:37 PM
  3. Replies: 7
    Last Post: 08-09-2015, 05:07 PM
  4. [SOLVED] Concatenate the values in a column one by one with multiple entries in another column
    By Pavan Renjal in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-11-2013, 08:13 AM
  5. Concatenate values in a column based on value of previous column
    By CountySurveyor in forum Excel General
    Replies: 3
    Last Post: 10-02-2012, 06:38 PM
  6. Replies: 8
    Last Post: 06-19-2012, 02:32 PM
  7. Compare cells in column 1 and concatenate values in column 2
    By sharmaremuk in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-20-2011, 09:04 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1