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.
<tbody>
</tbody>
| Name | Quantity | Dollars | Name | Quantity | Dollars | ||
| John | 5 | 25 | Brian | 5 | 58 | ||
| Joe | 8 | 75 |
<tbody> </tbody> | 8 | 75 | ||
| Kenny | 3 | 30 | John | 3 | 30 | ||
| Brian | 5 | 22 | Jenny | 6 | 50 | ||
| Jenny | 6 | 50 | Joe | 10 | 75 | ||
| Tim | 8 | 33 | |||||
<tbody>
</tbody>
