Results 1 to 18 of 18

Check a cell for a list of data, if found then print row

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2014
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    Check a cell for a list of data, if found then print row

    I have a tab with different city names and then a a series of answers to a number of different questions, what I need to do is create a macro which looks a table on a different tab, and if column b matches any of the words in the table to then print that entire row of answers.

    So if the information found in R1!M3:M21 is found in Results!B:B then print that row to sheet R1. If the information found in R2!M3:M22 is found in Results!B:B then print to sheet R2 etc.

    This is the only other way I could describe it, however I don't think it can be done as a formula anyway (even though it is somewhat gibberish)

    IF(ISNUMBER(SEARCH(R1!M3:M21,Results!B:B))print the row,move onto next row)
    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. Check for values in a table and if found add value found in column to left to list
    By robhargreaves in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-07-2013, 02:57 PM
  2. Replies: 7
    Last Post: 06-08-2012, 10:02 AM
  3. Check range for number if found paste data into cell
    By Sal1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2011, 03:29 PM
  4. Check for data in cell. If found paste text into same row another column
    By Buddy7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2011, 02:38 PM
  5. Excel 2007 : List of Cell Address for multiple data found
    By centurion210 in forum Excel General
    Replies: 7
    Last Post: 12-17-2009, 02:04 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