Completed

Add new functionality to existing excel macro

Please refer to the attached excel and word documents for a complete description and feel free to ask me any questions...

We want to modify the existing macro (GenerateMetricsAndQuotes) to create a new sheet called RATES, based on the current BUDGET

The current macro (GenerateMetricsAndQuotes) creates QUOTE and METRICS based on BUDGET

The new macro still creates QUOTE and METRICS and the additional RATES based on BUDGET

The sequence to create RATES is:

1. Create and delete columns to match the given tab RATES

2. Find the same TASK in MATERIALS and LABOUR. For example the task: “Flashings Colorbond”

3. Find pair of records (the pair if formed by a record under MATERIALS and a record under LABOUR) with the same text. For example “Roof Safety Mesh (90m2) Per Roll “. Sometimes there are records with only one component. For example: “CL 4 Type 17 12x65 (each)” is only in MATERIALS. “Labour Penetration_Large. 1menx0.5day($275)” can be found only under LABOUR. “Crane” is only under PRELIMINARIES

4. Move the LABOUR cost component of the pair to the new column “Labour Rate” sitting next to its corresponding MATERIALS component. If there is no pair but only MATERIAL component or LABOUR component, it is find, just place it and leave the other cell empty (refer to spreasheet “REPORT” for illustration of this case)

5. Leave the MATERIAL cost of the pair on the existing column “Material Rate”

6. The old record (row) for labour gets deleted

7. The record under PRELIMINARIES remain unchanged

8. The rows from “Not Coded” to the bottom row get deleted

9. The new worksheet RATES will have formulas that will calculate the MATERIAL COST = MATERIAL RATE x QUANTITY, and LABOUR COST = LABOUR RATE x QUANTITY.

10. The new worksheet RATES will add MATERIAL COST + LABOUR COST under the new column TOTAL

11. The yellow cell next to margin ie: is a formula. Its value is taken from a cell on sheet “QUOTE”. That cell, its location and value is determined by the existing macro. Its position changes on the different projects so the new program needs to name that cell with the name GPM_PROJECT and copy its value to the sheet RATES

12. Formatting as per the RATES sheet provided on the REPORT workbook

Please ensure that the current work of the existing macro GenerateMetricsAndQuotes does not get affected in anyway by the addition of new routine (it works very well at present).

Please note that the current macro has been tested to execute budgets with upto 200 scopes (very large budgets) and works well and a reasonable speed. Please ensure the new routine is also capable to execute for large budgets without detriment to its speed or accuracy.

Skills: Excel, Visual Basic, Visual Basic for Apps, Data Processing, Microsoft Office

See more: excel macro move data existing cell, install macro existing excel, excel macro add row fill data, excel macro add row increment, add references excel macro, check add install excel macro vba, add record as400 table using excel macro, excel macro reference existing internet explorer, excel macro chart dynamic columns rows, add functionality existing component joomla, add word special char excel macro, excel macro add internet explorer favorite, excel macro open existing email file, excel macro update existing tabs data main tab, open existing instance internet explorer excel macro, replacing existing contect excel macro, add data web existing excel spreadsheet, add-new-functionalities-existing-ios, add-some-functionality-existing-website/

About the Employer:
( 13 reviews ) Randwick, Australia

Project ID: #21336864

Awarded to:

TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$50 AUD in 1 day
(328 Reviews)
6.8

11 freelancers are bidding on average $35 for this job

aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$100 AUD in 2 days
(119 Reviews)
5.9
razvancotofana

Hello, I have substantial experience in excel and VBA, and I will be happy to assist you with your macros. Please contact me if you like to see my previous work and I will send some snapshots via chat. Looking forward More

$100 AUD in 3 days
(16 Reviews)
5.3
ironstar20311

Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing using Excel formula and VBA. Everyone calls me "PRINCESS of Excel". (. ❛ ᴗ ❛.) Here are projects I have done recent More

$25 AUD in 1 day
(21 Reviews)
4.6
care4rakib

I studied your work. I am good at Excel VBA & I am much interested working on this project and willing to start it immediately. Your project will be delivered in time with high quality. I can ensure you for speed and More

$10 AUD in 7 days
(6 Reviews)
3.0
MashoodMad

Hello I'm expert who knows the value of time,very hard working and always delivers the work on time. My motive is to make my employer happy without additional chargers. If you are looking for any kind of work, I'm the More

$10 AUD in 1 day
(1 Review)
1.2
xentricsoft5

Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements. We have More

$21 AUD in 7 days
(0 Reviews)
0.0
cyrilfeliciano

I have great skills in Data Entry and have been working as a Data Entry Operator for some time. I have lots of experience working with Editing and Excel. My prior responsibilities were Research Expert, Word Processing More

$20 AUD in 7 days
(0 Reviews)
0.0
majidraja16

Hii I'm Majid, actually, I read your project carefully and I have done this job perfectly don't hesitate to contact me ..thank

$10 AUD in 5 days
(0 Reviews)
0.0
mdomingo08

Hi I am here to work for you regarding this job role. I worked as an Admin Assistant for 2 years and as Technical Support for 5 months. I have expertise in this kind of skills to help you. Excited to hear from you soon More

$20 AUD in 30 days
(0 Reviews)
0.0
sofyanar95

Hi sir/madam, Im expert in microsoft office, expecially in excel and word. I can do the project wtih quickly and very well. I hope you interest about my bid. Thanks

$20 AUD in 3 days
(0 Reviews)
0.0