countryfan_n
06-12-2008, 07:02 PM
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
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