Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012

    Unanswered: Search Copy and Paste two columns in different sheet

    I guess this is a simple macro but I cant seem to get it. In the attached file you can see that there are two sheets. I want to search for the value in Sheet 2 (cell A1) in sheet 1 column B. If a match is found , I want to copy and paste the value of Column B and C from Sheet 1 to Column C and D in Sheet 2. I want to repeat this till the last row is reached and all values have been searched and pasted. I use vlookup and it works perfectly fine but I wanted to use a macro. Can someone please help?
    Attached Files Attached Files

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    Try the attached.

    I've only got Excel 2000 at the moment, and the code makes certain assumptions, but it seems to work.
    Attached Files Attached Files
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts