Sheet 2 is a data sheet with 2000 rows. Sheet 3 is a sheet with 1000 rows. Starting with the first row in sheet 3, I want to compare it to the rows of data on sheet 2 to see if there is an exact match in the first 6 cells of that row. If so I want the macro to copy the value in column “I” sheet 2 for that matching row and paste it on sheet 3 in column “O” for the row in question. Then go to the next row in sheet 3 and repeat the process till all 1000 rows are done. (note that there are some blank rows in both sheets)

Example:

Sheet 3 first 6 cells in a row starting in “A1” look like this
20131123 GG 5.5F D fMd8000 2F x x x...

If there is an exact match on sheet 2, sheet 3 will have copied “I1” from sheet 2 and pasted it at “O1” on sheet 3 . The above now will look something like this on sheet 3:

20131123 GG 5.5F D fMd8000 2F x x x... 76