Report Comparison

[dearly]

I have 2 reports, I want to use a key field to find the field into the other report and compare all columns after the key field, showing any differences. I'm looking for a formula to show on a different sheet the changes in list from day to day. Searching by the Name to find on the other report. Thanks for any help.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Quantity[/TD]
[TD]Dollars[/TD]
[TD][/TD]
[TD]Name[/TD]
[TD]Quantity[/TD]
[TD]Dollars[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]5[/TD]
[TD]25[/TD]
[TD][/TD]
[TD]Brian[/TD]
[TD]5[/TD]
[TD]58[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]8[/TD]
[TD]75[/TD]
[TD][/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]Kenny[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]8[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]Kenny[/TD]
[TD]3[/TD]
[TD]30[/TD]
[TD][/TD]
[TD]John[/TD]
[TD]3[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]Brian[/TD]
[TD]5[/TD]
[TD]22[/TD]
[TD][/TD]
[TD]Jenny[/TD]
[TD]6[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]Jenny[/TD]
[TD]6[/TD]
[TD]50[/TD]
[TD][/TD]
[TD]Joe[/TD]
[TD]10[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Tim[/TD]
[TD]8[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]