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

ranjanurs1496,

Sounds interesting and challenging.

You would have to supply me with copies of your workbooks, with copies of the raw data, and the finished product/worksheet, and, with detailed instructions.

I have used Excel extensively in my career. I have been able to save myself, and others, countless hours of boring, mundane, manual manipulation/formatting of data.

The last project I worked on for a group of six Financial Analysts, is projected to save their Firm 2,205 hours for one year.

If you like, you can send me a "Private/Personal Message" with your e-mail address, and I will contact you.


Have a great day,
Stan

__________________
stanleydgromjr

Windows 8.1, Excel 2007.

Hi Stan,

Thank you for replying.

My email Address : [email protected]

Please mail me i will reply to your mail with information.

Regards
Ranjan

Hi Stan,

Apologies for the delay.

Have sent you the working file to your hotmail account, along with the details.

Also tell me how can VB Code permanently kept on the Excel application for future use.

Please help me out.

Regards
Ranjan