Need a Excel MACRO to be created which can perform below actions :
1) Compare/Reconcile the data of 3 different files and generate report file from that reconciliation
2) MACRO has fields to enter data and it arranges it in a predefined report format
3) MACRO sends the report to predefined/desired mail ID's
A detailed explanation of the project is present in the file attached.