Microsoft Excel Visual Basic

Đã Đóng Đã đăng vào 5 năm trước Thanh toán khi bàn giao
Đã Đóng Thanh toán khi bàn giao

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.

Excel Visual Basic

ID dự án: #17601387

Về dự án

18 đề xuất Dự án từ xa 5 năm trước đang mở

18 freelancer chào giá trung bình$302 cho công việc này

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 trong 7 ngày
(106 Nhận xét)
7.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 Thêm

$222 AUD trong 3 ngày
(162 Nhận xét)
7.8
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 trong 3 ngày
(202 Nhận xét)
7.4
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 Thêm

$500 AUD trong 3 ngày
(94 Nhận xét)
7.5
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 Thêm

$201 AUD trong 3 ngày
(185 Nhận xét)
7.0
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 Thêm

$750 AUD trong 15 ngày
(17 Nhận xét)
6.3
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 Thêm

$50 AUD trong 2 ngày
(77 Nhận xét)
5.4
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 trong 7 ngày
(64 Nhận xét)
5.4
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 trong 5 ngày
(38 Nhận xét)
5.0
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 Thêm

$180 AUD trong 3 ngày
(3 Nhận xét)
3.8
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 Thêm

$250 AUD trong 3 ngày
(18 Nhận xét)
4.0
SamerHany

Hi, I am a chemical engineer with over 5 years of experience in MS Excel, macros, and VBA programming. I have considerable experience in the industrial safety field and would love to help with your project. Feel free Thêm

$100 AUD trong 2 ngày
(9 Nhận xét)
3.8
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 Thêm

$100 AUD trong 7 ngày
(4 Nhận xét)
2.9
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 Thêm

$166 AUD trong 3 ngày
(8 Nhận xét)
2.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 Thêm

$250 AUD trong 5 ngày
(3 Nhận xét)
2.4
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 Thêm

$99 AUD trong 2 ngày
(1 Nhận xét)
0.0