Microsoft Excel Macro for Automatic Bank Reconciliation Statement

[binuk]

Microsoft Excel Macro for Automatic Bank Reconciliation Statement



Dear Friends,


I'm sharing Microsoft Excel Macro for Bank Reconciliation Statement developed by me



Download the Macro Enabled Excel file from below link


Open the “Book Sheet” and copy paste the Bank Ledger in your Books in the necessary fields




Open the “Bank Sheet” and copy paste the Bank statements in the necessary fields





Then Go to “Reconcilation Sheet” and Click “Generate Reco” Button



It will process and give the reconciliation output





You can Drill down the details by Selecting the Cell and using “Ctrl + [“


Please Do not delete any sheet , It will corrupt the programme


Regards


Binu Kochupurackal
binu.yahoo.rediff@gmail.com



Download Link
Bank Reconciliation Statement_Developed By .xlsm download - 2shared
http://binukochupurackal.blogspot.in/2013/11/microsoft-excel-macro-for-automatic.html

 

[wigi]

Hello

The VBA-code is protected: in a learning and sharing environment such as this board, that is a pity.
Also, consider improving your code. For example, selecting and jumping to different sheets is not optimal.