+ Reply to Thread
Results 1 to 7 of 7

Macro to combine columns

  1. #1
    Forum Contributor
    Join Date
    10-04-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    161

    Macro to combine columns

    Hi,

    Looking for a Macro Solution. See attached example.
    Need to combine columns with the data on the row summed like the other unhighlighted columns.

    Thanks so much in advance.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2411 Win 11
    Posts
    24,409

    Re: Macro to combine columns

    It would be really helpful if you mocked up a solution so that it is clear as to what you want to happen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    10-04-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    161

    Re: Macro to combine columns

    As requested,
    See attached.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    29,774

    Re: Macro to combine columns

    Please Login or Register  to view this content.
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  5. #5
    Forum Contributor
    Join Date
    10-04-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    161

    Re: Macro to combine columns

    Hi, I tried the above code.
    After running the macro: the "After" sheet is just a duplicate of the "Before" sheet.

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    29,774

    Re: Macro to combine columns

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

  7. #7
    Forum Contributor
    Join Date
    10-04-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    161

    Re: Macro to combine columns

    Perfect...!
    Thanks so very much

+ 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. Macro to Combine data for Columns with same header
    By Pandrade in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-18-2020, 07:04 PM
  2. [SOLVED] Macro to combine Qty and Price Columns separated by Total Columns
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-17-2017, 02:46 AM
  3. Macro to combine three columns
    By bshelman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2015, 11:25 AM
  4. Macro to combine multiple columns keeping few columns specific
    By lramesh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 12:44 PM
  5. MAcro to - copy, transpose, text to columns, remove column A, combine all columns in 1
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-07-2013, 08:48 AM
  6. [SOLVED] Combine Columns in Macro
    By Rob in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-05-2005, 05: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1