Closed

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.

Kemahiran: Excel, Visual Basic

Lihat lagi: create xml excel visual basic, excel visual basic routine, excel visual basic bid price, vba pdf, vba excel 2016, visual basic for applications download, vba language, excel vba programming pdf, visual basic for applications, visual basic for applications office 2016, vba examples, excel visual basic function howto, convertir excel visual basic, excel visual basic script, excel visual basic chart, mssql excel visual basic script, generate data based columns excel visual basic script, projects using excel visual basic, deleting columns excel visual basic, money excel visual basic

Tentang Majikan:
( 1 ulasan ) Roxby, Australia

ID Projek: #17601387

21 pekerja bebas membida secara purata $299 untuk pekerjaan ini

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Lagi

$250 AUD dalam 4 hari
(609 Ulasan)
8.3
deepbluetech

Hi, I am an Excel macro expert and would be happy to take on your project. I have studies the files and can deliver the requirements within 3 days. Kindly confirm. Thanks, Arul

$250 AUD dalam 3 hari
(197 Ulasan)
7.3
dgled

Hi, 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 Lagi

$500 AUD dalam 3 hari
(55 Ulasan)
6.5
zekovicm

Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within th Lagi

$222 AUD dalam 3 hari
(70 Ulasan)
6.6
SPARKtechBD

Lots of experience on Microsoft Excel and Visual Basic to build any kinds of spreadsheet and building VBA Macros to automate data sheets. Have more than 15 years of experience on Visual Basic. I am hard working freelan Lagi

$750 AUD dalam 15 hari
(11 Ulasan)
5.5
SShtv

I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. I have successful experience performing similar work. This is one of them. https://drive.google.c Lagi

$175 AUD dalam 3 hari
(59 Ulasan)
5.6
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. I am also a PMP certified project manager and have domain expertise in Lagi

$201 AUD dalam 3 hari
(48 Ulasan)
5.3
tiaratechies

Hello, we are a team of certified excel experts from Microsoft Corporation if you are interested drop us a message to take this forward.

$1500 AUD dalam 7 hari
(37 Ulasan)
5.2
AlexandrUKR

please clarify deadline

$250 AUD dalam 7 hari
(19 Ulasan)
5.1
Mfaisalshahzad00

Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satis Lagi

$250 AUD dalam 3 hari
(16 Ulasan)
3.8
$444 AUD dalam 5 hari
(8 Ulasan)
4.1
ajittomar9

Dear Client, Greetings. My name is Ajit Tomar and I would absolutely love the opportunity to do build the new Risk Management template for you. I am an experienced excel and office automation expert freelancer on t Lagi

$180 AUD dalam 3 hari
(3 Ulasan)
3.8
haleem0786

I can do this. please review my profile and inbox me. I have good command over MS Excel especially povit table, charts, advance formulas, formatting, macro, VBA etc. thanks

$250 AUD dalam 5 hari
(14 Ulasan)
3.6
pnjadhav

Please review my profile I am working with skills that you required for this job for 16 years. I am working with MS Access, Excel, MS SQL, VBA and .Net for a long time. I can definitely help you with this job, to ma Lagi

$250 AUD dalam 5 hari
(3 Ulasan)
2.4
paulodayto08

Hi, Good Day! I can help you to complete this project. I am a VBA Macro developer and has strong knowledge in MS Excel formulas and functionality. I am also a PMO Analyst and my primary task is to generate and a Lagi

$50 AUD dalam 2 hari
(4 Ulasan)
2.5
dangphap

Hello, I am an expert Excel user with 3+ years of experience. I used to automate my daily tasks with VBA like the file you are using. I have a quick look at your file and find the macro is not too complex (although Lagi

$166 AUD dalam 3 hari
(5 Ulasan)
2.2
nishantha041

Dear Sir, I'm an engineer and hold a MBA also. Therefore I understand risk component as well. I have developed many excel VBA projects with regard to my profession. I can assure to develop the product you described. Y Lagi

$100 AUD dalam 7 hari
(3 Ulasan)
2.2
sevillajk01

hi! let me help you with your project. Just award the project to me and I will take care of the rest. thanks

$140 AUD dalam 7 hari
(7 Ulasan)
2.4
Grisha97924

I have good experience in excel vba. I can do it same by keeping previous function. I can start work now. Please. Regards.

$150 AUD dalam 3 hari
(0 Ulasan)
0.0
davidcastillo10

Hello, I have read your explanation and have reviewed the attachments and their code (forms, modules, book and sheets). I can do the job because I have experience programming in VBA for excel. I can even do something m Lagi

$99 AUD dalam 2 hari
(1 Ulasan)
0.0