How to write a reconciliation report in Excel?

Question

excel

Good day everyone! Please help with one not-simple, but very common task)))
There are three sheets with a unique sequence of dates: Shipment
Contracts , Payments. The client concludes a contract, makes an advance payment and receives the goods. How to collect data from three tables so that in the pivot table you can track when the contract was signed, when it was paid for and when there were shipments?)) Table example: https://docs.google.com/spreadsheets/d/12SLjP29vEQ.. .

Answer 1

VPR () will help the father of Russian democracy