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!

Hi cacaip,

How about a 2 sheet solution. Find the attached where I put sheet 1 of 123 on sheet 2 of ABC.

Then used conditional formatting to highlight any cell that wasn't the same on both sheets. It easily points out what has changed.

Does this help? Two worksheets is a lot easier than two workbooks. Do you really need two workbooks? What if there are multiple worksheets in each workbook? It could get messy.