+ Reply to Thread
Results 1 to 6 of 6

VBA Macro to find text string in one column and replace specific text in another column if

  1. #1
    Registered User
    Join Date
    12-31-2015
    Location
    Orlando, FL
    MS-Off Ver
    2016
    Posts
    11

    VBA Macro to find text string in one column and replace specific text in another column if

    I have a spreadsheet with data in columns A-J, rows 1-714. I need a macro to find the specific text sub-string "COE" or "Employee" in column F. If found, I need the macro to replace the value in column A, same row, with the string "Dona". I need the macro to do this in every row until no data is found in the next row. I've searched for examples but no success. Thanks!
    Attached Images Attached Images

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,934

    Re: VBA Macro to find text string in one column and replace specific text in another colum

    Post a sample workbook.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    12-31-2015
    Location
    Orlando, FL
    MS-Off Ver
    2016
    Posts
    11

    Re: VBA Macro to find text string in one column and replace specific text in another colum

    File attached...
    Attached Files Attached Files

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,934

    Re: VBA Macro to find text string in one column and replace specific text in another colum

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    12-31-2015
    Location
    Orlando, FL
    MS-Off Ver
    2016
    Posts
    11

    Re: VBA Macro to find text string in one column and replace specific text in another colum

    Works perfectly, thanks!

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,934

    Re: VBA Macro to find text string in one column and replace specific text in another colum

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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] Macro to find and replace cells in column that ends with certain text
    By michael.adams2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2016, 11:39 AM
  2. [SOLVED] Macro for find/replace specific text within a column
    By majkkali in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2015, 10:59 AM
  3. [SOLVED] Search through columns and find specific text and replace that text with header column
    By adamzee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2014, 11:59 PM
  4. [SOLVED] VBA to Search a Text String, Find a Value listed in another column and replace the text
    By Jschrod303 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-16-2012, 08:56 PM
  5. Need a Macro to do a find and replace for multiple text in just one column only
    By beepbeep27 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-10-2012, 12:47 PM
  6. [SOLVED] Find Specific Text in Text String and Return Value in Adjacent Column
    By watchouse in forum Excel General
    Replies: 2
    Last Post: 07-11-2012, 03:53 PM
  7. macro to replace specific data with column header text
    By wkilc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2010, 11:52 AM

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