Results 1 to 4 of 4

Thread: Solved: Copy row of sheet2 (if data does not match sheet1).

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Solved: Copy row of sheet2 (if data does not match sheet1).

    Hello friends,

    The attachment here has a code that works, I need to edit the code to:
    1. Go thru column A of sheet2.
    2. if the data in column A of sheet2 does not exist in column A of sheet1, then copy the active row from column A to column D (of sheet2), and paste the rows on sheet3.
    3. Start the pasting on cell A11 on sheet3.

    The reasons why the code that I attach is not enough, is due to:
    A. The code copies the matches between the two A columns (I don't the matches to be copied).
    B. The code only copies the last column of the matching A data (I need the entire row).

    Thanks a lot for your time & efforts,
    Nawaf
    Last edited by countryfan_n; 06-12-2008 at 07:21 PM.

Posting Permissions

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