Copy data from one spreadsheet to another spreadsheet, replace old data if not match

Hi,

I want to copy data from Spreadsheet 1 to Spreadsheet 2. Meanwhile, the data from Column D to I in Spreadsheet 1 may change, and will replace the existing data on Spreadsheet 2.

Spreadsheet 1

Column A B C D E F G H I
Row # Name Part Date1 Date2 Date3 Date4 Date5 Date6

Spreadsheet 2 will the same format as Spreadsheet 1.

Can someone please help?

Thank you.

Hi,

Please see attached file. ABC spreadsheet will copy the data to 123 spreadsheet, if there is no match find on Project ID, Name and Part. If someone changes one of the dates on ABC spreadsheet, for example: Date 2 to 4/1/11, the macro will replace Date 2 to 4/1/11 on 123 spreadsheet.

Hope this is clear, and thanks for the help!