Results 1 to 7 of 7

Trying to type in sheet1 that will search sheet 2 and return answer from sheet 2 to sheet1

Threaded View

  1. #1
    Registered User
    Join Date
    05-09-2014
    Location
    Denver, CO
    MS-Off Ver
    Excel 2013
    Posts
    4

    Trying to type in sheet1 that will search sheet 2 and return answer from sheet 2 to sheet1

    I hope that I can explain this problem correctly. What I am trying to do is type a specific computer model in sheet1. The in turn. Will start a search in sheet2 that has all the models in column A. This will copy the Yes/No answer from sheet2 column B to the correct column in sheet1. Very new to VB coding and macros. Im thinking I need a loop that will do a search and copy. Than a secondary set of code to past. Every time I try something. I FUBAR my excel sheets. Can do formulas decently. But I dont think a formula is the way to go. Thank you for your help.

    Sheet1
    Column B
    Model (lable of column B)
    HP T610 (Thin Endpoint)
    HP DC 5100
    MAC G3 (example computer)

    Column D
    Win 7 Compatible?(Lable of column C)
    Yes
    No
    ? (Need to populate this column with Yes/No from sheet2)

    Sheet2
    Column A
    Model
    HP T610 (Thin Endpoint)
    HP DC 5100
    MAC G3 (Need to search and find this model from sheet1)

    Column B
    Win 7 Compatible?
    Yes
    No
    No (Need this to transfer to Sheet1 column D)
    Last edited by semperfresh; 05-09-2014 at 03:33 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. =+Sheet1!A1+Sheet1!B1+Sheet1!C1 macro to convert all linked ref to Values
    By chriszoma in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-20-2013, 02:44 PM
  2. Copy certain data from Sheet1 to Sheet 2 based on values in a column on Sheet1
    By theglitch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2013, 01:28 PM
  3. Compare Sheet1 and Sheet 2 and Remove Matching Records from Sheet1
    By MotoDave in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2013, 12:35 PM
  4. merge book1,sheet1,book2,sheet1,book3,sheet1 ect
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2013, 01:30 PM
  5. [SOLVED] I need a formula to return a column of data from sheet1 into sheet 2
    By DustOfTheEarth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 06:36 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