Results 1 to 9 of 9

Search each row for string, put result in last column

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2012
    Location
    Uk
    MS-Off Ver
    Excel 2010
    Posts
    98

    Question Search each row for string, put result in last column

    Hi All

    I am hoping someone can help, as the more I look for a solution the more confused I get about loops and find().

    Is it possible to use VBA to search through rows of data for a specific string (say 'Apples') and then insert a boolean result in the final column. It'll be for datasets no more than 300-1500 rows long, 15-20 columns wide

    Picture2.png

    Any advice would massively appreciated
    All the best
    Vicky
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Search a row for a string and return result
    By Margate in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-30-2019, 08:08 AM
  2. Search column for string and date then search adjacent cell and pop up message
    By ftwobtwo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2014, 09:55 AM
  3. Replies: 1
    Last Post: 09-11-2014, 10:59 AM
  4. Search column for string and return every row with that string in new sheet
    By myers601 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2012, 06:02 PM
  5. [SOLVED] Search for string across header row, then search for another string down found column
    By TucsonJack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2012, 02:09 PM
  6. Replies: 1
    Last Post: 07-26-2011, 06:48 AM
  7. How do to search for a string in excel across all rows/columns and save the result?
    By akondeti in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-07-2006, 07:16 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