Copy and Compare data from two worksheets

[tejboyd]

Hi,

I have a workbook that has stored data in one sheet and each week I receive a new spreadsheet and have to manually copy across and compare the values.

The macro needs to copy across the data and if all the information matches don't paste the information. But if one of the cells is different then paste the information.

Below is and example of the data that is in both sheets.

19999 44444 45555 13333 SMITH/JOHN MR 14/10/2014 17/10/2014 AUSTRALIA XX/XXXXXX/XXXX SYDNEY UNITED KINGDOM LONDON QANTAS 777 2

Hope this makes sense.

[Pauleyb]

A macro could be written, but it is probably not worth the effort. Just paste everything into the 'archive' table, then use Data->Remove Duplicates.

[tejboyd]

Thanks for the repsonse.