Sometimes you need to place data from compared workbooks to new worksheet without changing
compared workbooks. xlCompare has a button Merge differences to new worksheet:
It adds new worksheet to compared workbook and shows it on the Comparison Report Dialog: