Move data from compared sheets to new worksheet
Move data from compared sheets to new worksheet.
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:
Now you can move data between this 3 worksheets.
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.