+ Reply to Thread
Results 1 to 3 of 3

How to copy a row of data from sheet 2 if two cells' values match cells' values in sheet 1

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    DC
    MS-Off Ver
    Excel 2013
    Posts
    9

    How to copy a row of data from sheet 2 if two cells' values match cells' values in sheet 1

    Thread title is incorrect. I've realized that the problem is much simpler.

    How to copy a row from Sheet 2 if A2 is an exact match of A2 in Sheet 1?



    Thanks!
    Last edited by jfrost88; 11-19-2013 at 03:49 PM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: How to copy a row of data from sheet 2 if two cells' values match cells' values in she

    So you want to check if A2 in Sheet2 matches A1 in Sheet1? Where should the data be copied? In column B in the same row?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague, Czech rep.
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    138

    Re: How to copy a row of data from sheet 2 if two cells' values match cells' values in she

    Hi Jfrost88,

    there are kinda two options. Depends what you wanna do next with the data or if there is any request on how they should look like at the end etc. a bit more of description would be cool if you could provide us to give you proper solution...or sample file (which is always the best way to give us, forum guys, better chance of knowing of what you´re trying to do).

    best regards

    Soul

+ 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. Replies: 6
    Last Post: 09-13-2013, 01:29 AM
  2. Replies: 1
    Last Post: 04-11-2013, 01:02 PM
  3. Replies: 5
    Last Post: 02-21-2013, 07:17 PM
  4. Copy Values to cells on second sheet does not fit in cells
    By imaquila in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2012, 04:48 PM
  5. How can I copy the values of all selected cells to the same cells inanother Sheet
    By hans.domian@de.man-mn.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2006, 12:50 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