Hi,

I have 2 worksheets, one is version 2 (latest) and the other is version 1.

Version 1: I have few columns as below with data input and there are 28 rows of data.
Date
Employee ID
Project
Workcode
Hour
Rate
Amount
Invoice No.

Version 2: I have the same columns as in version 1 but with 40 rows of data (Invoice column is blank).

:: In version 2 worksheet, I need to copy the invoice number from version 1 based on the exact match of all the columns in version 1.

If version 1 has 1 row of data but version 2 has 2 row of data with exact value, I need only 1 invoice no. copy to version 2 for 1 of the 2 row of data.