Find Jobs
Hire Freelancers

Building a VBA based dashboard on Excel

$10-30 USD

Completed
Posted over 7 years ago

$10-30 USD

Paid on delivery
In a summary: User opens the dashboard workbook and input source file name. Copy data from a few tabs from source file. Paste them into PD and W tabs in the dashboard workbook. Build charts in the individual tabs in accordance to the structure set out in the TEMP tab. Detailed instructions are in the dashboard file, menu tab. Challenge: Making sure that the correct sections of data is pasted. Please make sure enough space is given between sections because sometimes the volume of data can change. It can be more. Ensuring the charts structure follow the Temp data. Requirement: Coding is neat and has proper understandable comments.
Project ID: 11890540

About the project

7 proposals
Remote project
Active 8 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 developed several such projects that i can show u as example as well. since i have similar experience so it can give u better results than others. inbox me to discuss
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
7 freelancers are bidding on average $91 USD for this job
User Avatar
Dear Sir/Madam, I have 4 years of experience in Excel VBA programming. I used to work for a company called InvestorForce (MSCI) where I created automated solutions for analyzing and visualizing financial data. The instructions are clear. Regarding the required extra spaces between sections, it is not necessary to leave extra rows, I will make it dynamic so that it counts amount of rows to copied so there will be only one empty row between them. The charts' reference will be also dynamic. Regards, Balint Kolosi
$135 USD in 4 days
5.0 (28 reviews)
4.7
4.7
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$150 USD in 4 days
4.9 (25 reviews)
5.0
5.0
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel Sir :) please give me a chance for doing your project and im able to start doing your project Thank You Sincerely Prameswara
$30 USD in 1 day
5.0 (26 reviews)
4.7
4.7
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$100 USD in 2 days
5.0 (9 reviews)
4.1
4.1
User Avatar
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 USD in 3 days
4.4 (18 reviews)
4.6
4.6
User Avatar
Hello, I will draft VBA code that will that will pull the requested data from the source file into several tabs in the dashboard workbook and create charts on each tab as per the charts in the Temp tab. Will test the code to ensure that data pulls correctly, that sufficient space is maintained and that each part of the code is properly commented. I am new to freelancer but have worked with advanced formulas, macros etc. as a budget analyst for a very high-volume global health organization, where we had to review, create, modify, etc. very complex Excel budgets and budget templates from all over the world on a daily basis. Thanks, caugustus3
$95 USD in 3 days
5.0 (1 review)
0.4
0.4
User Avatar
hello. nice to meet you. I can do this project..but please consider about the project budget more. Best regards. Thanks.
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, Hope you are doing well!! we have closely reviewed your project description and understood that you need a Excel Macro It would be my pleasure to have this opportunity of working with you. We will exceed your expectation with my true dedication of work. Thanks for your priceless time and it will be great for us if you consider us for your work. We have rich experience in Excel Macro for big companies and individuals. we have 7 year of experience in Excel Macro development Please message me for further communication and let me know if there is any issue. So, I can complete your project within your timeline, finely. I will do my best with your project by following you. So, I can complete your project within your timeline, finely. I will do my best with your project by following you. Please inform me. I am waiting for your good reply. Looking forward to hear from you soon. Thanks and regards,
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
4.8
2
Payment method verified
Member since Jul 1, 2016

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.