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:
We suggest you to review topic
Quickly move data from one worksheet to another.
It describes which features you can use to quickly move data between compared sheets.