-
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
-
Forum Rules