Hello




I've used Spreadsheet Compare to compare 2 spreadsheets and got Export results sheet as an output.


Does the Program have a switch or option functionality of giving me a better, user-friendly output that shows me which rows have been deleted, added or changed on the sheets?


I'm not looking to post-process the data in any way or format using macros or VBA. I just want to view the changes marked in both sheets preferably if the Spreadsheet Compare program can perform it.


Any help would be greatly appreciated!
Thanks.

Attached Images

	compare.jpg (189.1 KB, 14 views)
	export_results.jpg (180.1 KB, 14 views)

crossposted at multiple sites:
crossposted at: | MrExcel Message Board and
Spreadsheet Compare Output | Chandoo.org Excel Forums - Become Awesome in Excel and

Spreadsheet Compare Output

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2510

I'd probably use a report workbook with queries on hidden pages.
1st query gets PropertyID's plus any other data you need from both spreadsheets where PropertyID in both of them is present, and any of other fields was different, plus comment field composed;
2nd query gets PropertyID's plus any other data from 1st spreadsheet where PropertyID in second one was missing, plus additional comment field;
3nd query gets PropertyID's plus any other data from 2nd spreadsheet where PropertyID in first one was missing, plus additional Comment field.

NB! All 3 queries must return the same number of fields!

Now you create a report sheet, with uses UNION query to read info form 3 hidden ones, ordered by PropertiID.