+ Reply to Thread
Results 1 to 2 of 2

Macro Search Function to Return Values on Specified Cells

  1. #1
    Registered User
    Join Date
    08-05-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    22

    Question Macro Search Function to Return Values on Specified Cells

    Hi,

    I have an Excel file which consists of 2 sheets (Sheet1 and Sheet2)

    On Sheet2, I have 3 column (A, B and C)

    I need a macro to search column C on Sheet2 and Look for any Cells with any data and return the column A Value on Sheet2(Same Sheet) and print it to Sheet1 (on the F Column)

    Any help greatly appreciate

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Macro Search Function to Return Values on Specified Cells

    Hello
    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

+ 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 table for unique values return values and corresponding cells to a different sheet
    By thara95 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2017, 09:04 AM
  2. Replies: 4
    Last Post: 10-01-2015, 11:01 AM
  3. Replies: 6
    Last Post: 03-12-2015, 01:35 AM
  4. Search through a specified workbook and return values from specified cells.
    By beenbee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2013, 10:34 AM
  5. [SOLVED] IF-ISTEXT-SEARCH, to return values from multiple cells
    By CClio333 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-21-2013, 05:10 PM
  6. Function to search Column for a range of values and return TRUE or FALSE
    By BamBamMoneyBags in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-05-2013, 05:59 AM
  7. Replies: 3
    Last Post: 05-23-2012, 10:18 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