Results 1 to 7 of 7

How to search for a keyword and return the ENTIRE cell contents to a new sheet?

Threaded View

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    8

    Question How to search for a keyword and return the ENTIRE cell contents to a new sheet?

    Based off the keywords in column A on SHEET ONE I want to search SHEET TWO for those keywords. The keywords will only appear once in a single cell on sheet two.* I then want to return the ENTIRE contents, not just the matching keyword, of the cell containing that keyword to column B on sheet one. I've attached an example excel file showing what I'm trying to do.

    Thanks in advance for you help!
    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 for the keyword with and condition and return to the different sheet within excel
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-18-2014, 11:05 AM
  2. [SOLVED] keyword search - a macros to change font color for specific key words (not entire cell)
    By kingwhopper in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-10-2014, 12:25 PM
  3. Replies: 6
    Last Post: 03-18-2014, 11:16 AM
  4. [SOLVED] Formula to search from keyword list and return adjacent cell
    By Ninja2k in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2013, 08:44 AM
  5. Return Cell Contents by Sheet Name Search
    By gratedwasabi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-26-2012, 10:45 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