Microsoft Excel Visual Basic

I am using an old Excel Spreadsheet that has been modified with many Macros to automate a "Risk Management Tool". At the click of a button, I can choose the severity and likelihood factors for risk ranking work tasks on a construction site. There is an "Add-Ins" tab that allows the user to insert rows, delete rows, rank risks from highest to lowest, number the tasks, sort order and many other things. The problem I have is that I want to upgrade the risk tool so it uses a larger RISK MATRIX. Where there were 25 possibilities to rank risks from Low to Extreme, I need to expand to 42 possible risk rankings.

I have attached 3 spreadsheets:

• ORIGINAL WRAC [login to view URL]

• ORIGINAL WRAC TEMPLATE (Populated).xlsm

• NEW WRAC TEMPLATE .xlsm

I have already done a lot of work on the NEW WRAC TEMPLATE. It has the Risk Matrix I want to use with 42 boxes and the new ranking system. I would like someone to make this new template to work exactly like the ORIGINAL WRAC TEMPLATE does.

I have Populated the ORIGINAL WRAC TEMPLATE (Populated) with some items so you can see how the spreadsheets macros work. In the "Add Ins" tab are all the Macros. The "Update Tables" button ranks all of the items into the Risk Map (Before Treatment and After Treatment) and lists them in the "Risk Summary" from the highest to the lowest risk.

This gig requires you to create a new Workbook out of the NEW WRAC TEMPLATE format that works the same as the Original Template does when you "Update Tables". The successful bidder will know how to write Visual Basic and re-write the code so that the new risk matrix is functional.

I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (Lisää

"Hello,
I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional worLisää

Hello. I read your proposal, but apparently, the other 25 freelancers that are bidding at the moment did not read it. How do I know? Because I read each of their proposals, and not a single one mentioned that you did Lisää

Hi.
My name is Albert and if I want I can help you in your project. I have a lot of experience in Excel (including formulas, macros and VBA). If you are so kind to visit my profile you can check it yourself.
I wantedLisää

Dear Employer
Please assign this task to me. I will help you out in finishing within the deadline.
I have a very good knowledge in doing VBA aka macros in Excel.
Please feel free to chat with me.
Thanks aLisää

Hi,
I can do it with the best quality and accuracy because I'm an expert on Excel VBA.
Please review my portfolio.
You'll find me available 24/7 via Skype or Phone.
Let me know more about your project via Chat.
Lisää

Welcome to Notes
dear employer we will give you best result by using my experience and excellence academic skills on your project. You can chat with me and lets get started. thank you.
Relevant Skills and Experience
ILisää