Hi,
Am An Accounting Professional, i have downloaded Bank Statment from the Bank's website & converted to Excel format & ERP system will be having Cash & Bank Account (GL Account) where in Entries are posted for Receipts & Payments from Customer & vendors converted to excel format.

Now, i need to reconcile the Cash/Bank Account with Bank Statments and result should be saved to a New Excel Sheet within same Workbook.

Could you help me to Automate this Reconciliation Process (this reconciliation has to be done on a daily basis for huge data) i need VB Code(VB macro).

Also help me with on How these Macros can be stored permanetly on excel for future use since, this is a repetative task?

Regards
Ranjan