I need an expert in Visual Basic for Applications to create Macros
- or -
Post a project like this1998
$150
- Posted:
- Proposals: 5
- Remote
- #2174886
- Awarded
Description
Experience Level: Expert
I need and expert in Visual Basic for Applications to create Macros in order to automate tasks in Excel by writing so-called macros. This is for a project repeated every 3 months. Attached are the spreadsheets we have put together. I also attach the end result which gets fed through the excel information.
We take the financial statements for ten banks in one given country. We then input all info on to the excel model. Only on the input sheets. They automatically get synchronised into the output sheets. We then transform that automatically to the attached ppt presentation. We write the comments but all graphs etc are done based on formulas. Can you do this? The task is to review the attached spreadsheets and make sure all formulas are correct and information flows through correctly to the output sheets. And then, you have to use the right program to produce the graphs and tables like in the document I'm sending here.This is a project that we have to do every 3 months. If the person awarded this project does a good job and makes my life easier by producing quality model and end product, this is a routine piece of work.
This request is for 1- Oman Banking Pulse, 2- Kuwait Banking Pulse, 3- Islamic Banking Pulse, 4- Turkish Banking Pulse. Oman is just to review the formulas and make sure all works very well.
Kuwait is already checked and needs to be cleaned up as there are formulas that don't work.
Islamic Banking one needs a thorough review of data and and formulas.
Turkish Banking Pulse - we need to create the template for this one.
Thanks
We take the financial statements for ten banks in one given country. We then input all info on to the excel model. Only on the input sheets. They automatically get synchronised into the output sheets. We then transform that automatically to the attached ppt presentation. We write the comments but all graphs etc are done based on formulas. Can you do this? The task is to review the attached spreadsheets and make sure all formulas are correct and information flows through correctly to the output sheets. And then, you have to use the right program to produce the graphs and tables like in the document I'm sending here.This is a project that we have to do every 3 months. If the person awarded this project does a good job and makes my life easier by producing quality model and end product, this is a routine piece of work.
This request is for 1- Oman Banking Pulse, 2- Kuwait Banking Pulse, 3- Islamic Banking Pulse, 4- Turkish Banking Pulse. Oman is just to review the formulas and make sure all works very well.
Kuwait is already checked and needs to be cleaned up as there are formulas that don't work.
Islamic Banking one needs a thorough review of data and and formulas.
Turkish Banking Pulse - we need to create the template for this one.
Thanks
Tulay F.
100% (3)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
15 Oct 2018
United Arab Emirates
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies