+ Reply to Thread
Results 1 to 6 of 6

Concatenate 3 columns but triggered when data is placed in a different column

  1. #1
    Registered User
    Join Date
    09-22-2013
    Location
    Aurora, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    30

    Concatenate 3 columns but triggered when data is placed in a different column

    Hello: could someone please help me with a simple macro to:

    concatenate column E, I, and G (in that order) with spaces in-between and display the result in column J.
    This action is triggered when data is placed in column D.
    And this concatenation would apply to rows 3 to 1000

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Concatenate 3 columns but triggered when data is placed in a different column

    Hello & Welcome to the Forum,

    Try...

    Please Login or Register  to view this content.
    Paste code in a Sheet module
    • Where to paste code
    • Highlight macro to copy >> Ctrl + C >> Open your workbook
    • Right click on sheet tab >> View Code >> opens the Visual Basic Editor (VBE)
    • Ctrl + R >> opens the Project Explorer (if not already open on left side of screen)
    • Paste code >> Ctrl + V (right side of screen)
    • Alt + Q >> exits VBE and returns to Excel
    • Now simply make a change in target cell
    HTH
    Regards, Jeff

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: Concatenate 3 columns but triggered when data is placed in a different column

    This one worked for me.

    Please Login or Register  to view this content.
    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

  4. #4
    Registered User
    Join Date
    09-22-2013
    Location
    Aurora, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Concatenate 3 columns but triggered when data is placed in a different column

    This worked very well, thank you so much. I neglected to include in my requirements, specifically regarding the trigger in column D, that the entry in D will most likely be an entry that is pasted. Is there a way to write the code so the action will be triggered if the entry in column D is typed or pasted?

  5. #5
    Registered User
    Join Date
    09-22-2013
    Location
    Aurora, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Concatenate 3 columns but triggered when data is placed in a different column

    Thanks for your quick response. I think the code that was provided by jeffreybrown is closest to what I need except for the comment I just included in a reply to him. I do appreciate it though.

  6. #6
    Registered User
    Join Date
    09-22-2013
    Location
    Aurora, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Concatenate 3 columns but triggered when data is placed in a different column

    Is there a way to change the code so the concatenation will be triggered if data is pasted into column D? Right now the code only works if something is typed into the cell.

+ 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. Replies: 6
    Last Post: 06-13-2016, 11:23 AM
  2. Nested loop to concatenate 2 columns of data
    By JohnnyBGood in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2015, 07:42 AM
  3. Concatenate data in 3 columns for each row matching the full name
    By mcain1981 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2013, 06:49 PM
  4. Concatenate from columns of dynamic data
    By ksp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2006, 05:28 AM
  5. [SOLVED] Cobining more than 30 columns of data with concatenate.
    By JT in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-28-2005, 11:05 PM

Tags for this Thread

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