Microsoft Excel Visual Basic

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

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.

Copy Typing Data Entry Excel Visual Basic

Project ID: #18182542

About the project

31 proposals Remote project Active 5 years ago

31 freelancers are bidding on average $171 for this job

dgled

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 ( More

$250 AUD in 3 days
(94 Reviews)
7.5
The24CarrotsInc

Hello, We can do this with 100% Quality with On-time delivery. Please allow us to take this opportunity. Thanks.

$100 AUD in 2 days
(72 Reviews)
5.9
carlosperezit

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$222 AUD in 10 days
(33 Reviews)
5.2
dataexplorer

"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 wor More

$150 AUD in 3 days
(25 Reviews)
4.9
AMC1979

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 wanted More

$150 AUD in 5 days
(6 Reviews)
3.0
dvdalon

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 More

$225 AUD in 4 days
(3 Reviews)
2.3
sami37627

*******************************What I am Offering in this Gig?********************** I will do data entry work for any level and deliver you in provided time with 100% quality and efficiency. Services Data Entry More

$233 AUD in 2 days
(0 Reviews)
0.0
webscraper24

"Greetings! According to your stated project description you need an Google sheet and excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just se More

$250 AUD in 3 days
(2 Reviews)
0.0
sameerana08

No way

$155 AUD in 3 days
(0 Reviews)
0.0
$35 AUD in 2 days
(0 Reviews)
0.0
Punjtheabhi

I m an expert in microsoft excle. With a experience of 3 years Relevant Skills and Experience I am a professional data entry worker for a chartered accountant firm

$155 AUD in 3 days
(0 Reviews)
0.0
vipuljotaniya189

Available Relevant Skills and Experience Computer efficient

$155 AUD in 3 days
(0 Reviews)
0.0
dlekurwale

Sir, I have excellent knowledge of excel with more than 3 year provided high speed. I will not disappoint you also, delivered work in time with high accuracy. Relevant Skills and Experience I have excellent knowledge More

$155 AUD in 3 days
(0 Reviews)
0.0
Shariefzahramin3

Sir can u please hand over to me this job. I will work for the best to complete this work. I request u sir

$30 AUD in 2 days
(0 Reviews)
0.0
Bachi2001

i have excellent skills i have excellent skills i have excellent skills i have excellent skills i have excellent skills i have excellent skills i have excellent skills i have excellent skills

$55 AUD in 3 days
(0 Reviews)
0.0
sanjeet641

I want a data entry project.

$30 AUD in 30 days
(0 Reviews)
0.0
Geraldjay55

Hello Good day, I'm Gerald Jay Cabigon. I'm interested of your Job posting. If got a chance I will be your asset and not a liability in your company. You can contact me this number +639675789434 Relevant Skills and Ex More

$166 AUD in 3 days
(0 Reviews)
0.0
Nilesh223

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 I More

$30 AUD in 1 day
(0 Reviews)
0.0
navnathak47

Copy writing

$155 AUD in 3 days
(0 Reviews)
0.0
ghullamnabi

I will do it in smoothly.

$155 AUD in 5 days
(0 Reviews)
0.0