Find Jobs
Hire Freelancers

simple Excel VBA Macro needed

$10-30 AUD

Completed
Posted over 6 years ago

$10-30 AUD

Paid on delivery
Values from and excel table (in a sheet called BUDGET) need to be extracted and put into a smaller table on a new sheet (called METRICS). The workbook might have many other sheets in it so the program must specifically work only on the sheet called BUDGET and the new sheet METRICS without altering any other sheet New sheet METRICS will be created by the macro The new table will have formulas referring to the cells from the original table (not just copying the values but inserting a reference). See attached spreadsheet for an example. The original table (in BUDGET) has 3 parts, namely: MATERIALS-(M) LABOUR-(L) PRELIMINARIES-(P) Within each of these 3 parts, there will be one or many scopes. scopes name always starts with the suffix SCOPE. For example: SCOPE 1_, SCOPE 2_, etc The example attached shows only 2 scopes but there could be more. The macro is to find how many scopes there are and possibly loop as many times as required The macro will then create the new sheet (METRIX) and will populate with the reference to the values in BUDGET. See attached spreadsheet FORMATING: For clarity I have highlighted the cells that are referring to each other with many different colours but it will be ideal if a single colour per scope could be used. For example: the items on SCOPE 1 in light blue (on both sheets: BUDGET and METRICS), the items on SCOPE 2 in light yellow, etc Please suggest the best methodology to achieve this, is a nested loop required? Or would simple array formulas do the trick?
Project ID: 15478756

About the project

10 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I have opened attached file and I have many ideas how to solve it. I call such projects peace of cake. It's possible to complete in couple of hours, or maybe even in 1 hr. Maybe even sooner, but I rarely estimate with accuracy less than 1 hour. Relevant Skills and Experience Despite my primary area of expertise is C++ and Windows API, I have enough experience with Excel and Visual Basic for Apps for writing macros. Also, I have strong background with mathematics and algorithms Proposed Milestones $18 AUD - Macro for calculations About your suggestion, I can answer follow thing: nested loops are more reliable, array formulas make more quick code. What is better, it depends what does matter for you.
$18 AUD in 1 day
4.9 (337 reviews)
6.4
6.4
10 freelancers are bidding on average $33 AUD for this job
User Avatar
HI, I am good at Excel and vba. I prefer vba for this case. I can link the formulas. I can get all the scopes and complete all the columns in metrics. Program will not touch other sheets. -Chandra Relevant Skills and Experience Excel vba, Data Transfer Proposed Milestones $34 AUD - Milestone
$34 AUD in 0 day
5.0 (777 reviews)
7.8
7.8
User Avatar
Greeting, I have understood your excel Macro task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Data Processing, Excel, Visual Basic Proposed Milestones $100 AUD - extract values from tables
$100 AUD in 2 days
4.8 (13 reviews)
5.3
5.3
User Avatar
Hello, I am Luis from Venezuela and it will be my pleasure to assist you in this matter. I can help you to solve your excel requirement Habilidades y experiencia relevante excel expert, visual basic for apps Htos propuestos $25 AUD - excel macro Please contact me by chat then we could discuss better your project! Luis Romero
$25 AUD in 1 day
4.9 (93 reviews)
5.1
5.1
User Avatar
Hi There... I've read your brief and downloaded your attachment. I think I can do but I have to change the budget format (maybe add some hidden column). So it easier to be read by the macro loop. Relevant Skills and Experience I did many excel macro projects here. Some of them are as complicated as yours. I hope we'll discuss further. Proposed Milestones $35 AUD - VBA Macro
$35 AUD in 3 days
5.0 (40 reviews)
4.5
4.5
User Avatar
hi, I am very good in excel and this is very simple for me you can trust me for this project. thanks
$25 AUD in 1 day
5.0 (15 reviews)
3.8
3.8
User Avatar
I will modify my existing MS Excel VBA scripts to create a new sheet METRICS for each 'SCOPE' to populate with the reference to the values in BUDGET. Relevant Skills and Experience I have been coding in basic & MS Office (Word, Excel, PowerPoint etc...) VBA script since 2000. Proposed Milestones $25 AUD - Project Successfully Completion How soon do you need this project?
$25 AUD in 1 day
5.0 (1 review)
3.4
3.4
User Avatar
Hi I am interested to project. I saw your project and read its details. I am fully expert this job. I want to do its because i am sure i can do its. thanks. Relevant Skills and Experience Data Processing, Excel, Visual Basic Proposed Milestones $15 AUD - project milestone
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Randwick, Australia
5.0
5
Payment method verified
Member since Dec 17, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.