+ Reply to Thread
Results 1 to 5 of 5

VBA Code: Search column for text match, if found add text into row

  1. #1
    Registered User
    Join Date
    12-15-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    18

    VBA Code: Search column for text match, if found add text into row

    Hello

    Would anyone be able to help me with some code:


    I have text in Column I and if it matches GREEN it needs to paste the word TRUE in column F but on the same row? (It would need to search until the last entry in column I)

    Please see screenshotMOVE.jpg
    Last edited by markpem; 12-18-2014 at 07:02 AM.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: VBA Code: Search column for text match, if found add text into row

    is the GREEN etc just an example, or do you literally just need to add the word TRUE against every item with GREEN in column I?

    If so then you dont need VBA, either add the following in F1 and drag it down
    Please Login or Register  to view this content.
    or filter column I on "GREEN" type TRUE in the first item and drag down to the bottom.
    If someone has helped you then please add to their Reputation

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: VBA Code: Search column for text match, if found add text into row

    Maybe:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    12-15-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    18

    Re: VBA Code: Search column for text match, if found add text into row

    Hi John H Davies,

    Thankyou for the code you took time out of your day to provide. It worked wonderful and you've made a great impact to my day. Thankyou again and all the very best.

    Mark

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: VBA Code: Search column for text match, if found add text into row

    You're welcome. Glad to help out and thanks for the feedback. Please comply with the Forum Rules and mark this thread as solved. See below:

    http://www.excelforum.com/forum-rule...rum-rules.html

    By the way the general way to show appreciation on the Forum is too click the add reputation button in the lower right hand corner of the post.

+ 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] Search multiple Text Criteria in one column, and if found, rename it in a different column
    By gbloemke in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-24-2014, 07:18 AM
  2. Replies: 1
    Last Post: 11-05-2012, 09:23 PM
  3. Replies: 3
    Last Post: 10-25-2012, 12:49 AM
  4. [SOLVED] search column for text, if found, paste value in a different column in new sheet
    By wkarnadi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-17-2012, 10:29 AM
  5. Search column - return row found in long text string
    By JayL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2005, 12:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1