If you look at what he is asking to do, the merge and compare function of shared workbooks would do what he is looking to do.



Merge copies of a shared workbook
http://office.microsoft.com/en-us/ex...010177169.aspx

Yes I know that. But unless I'm mistaken he was talking about completely detached copies of the same workbook and thinking that these could be merged with the standard Workbook merge functionality. e.g. books called Book1, Book2, rather than multiple copies of Book1 on a common server.

Am I mistaken and you can merge Book1 and Book2 in the way envisaged?

Regards

Yes, you can merge seperate workbooks (book1, book2) if:

1) the orginal was a shared workbook (call it book1)
2) And the other workbook (book2, book3, etc) derived from book1 (book1 saved as book2 and so on)

So basically he'll be able to open his copy book1 and merge/compare the other copies he got back (book2, book3, etc) using the merge/compare functionality.

The button isn't exposed by default, will need to add it to the QAT. Haven't heard from the OP on this, but from what I understand this is what he is trying to accomplish