Create a macro in Excel to display dashboard

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

I use an application that exports some data in a .xls file. I would like to have a macro written that imports the file and creates a new .xls file with some better dashboard guages. I would like to keep the existing data in the file but display it along with 3 new dashboard speedometer objects. I'm thinking something like this: [login to view URL] There are a couple of new (but easy) calculations I would like to run on the existing data in the file. Basically I would like to make the existing file prettier and display the data better, and I dont have control of the application that creates it. I would like it to be as automated as possible. I've attached an example file.

Excel Visual Basic

Project ID: #11472090

About the project

35 proposals Remote project Active 7 years ago

35 freelancers are bidding on average $129 for this job

schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I Have More

$90 USD in 1 day
(315 Reviews)
7.8
Teloquence

EXCEL/VBA expert at your service. Please check my past reviews for your reference. Looking forward for your reply so that i can start with the implementation.

$250 USD in 2 days
(335 Reviews)
7.7
elqueabandona

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 rega More

$200 USD in 3 days
(220 Reviews)
6.9
ksriniravi

Greetings Hiring Manager! I viewed the YouTube Video and understand what you are expecting. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of autom More

$50 USD in 3 days
(184 Reviews)
6.8
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 280 projects. Please look at the feedback left by my employers to know more about my work. Wai More

$120 USD in 4 days
(120 Reviews)
6.3
atifdar

Hi, MS Excel expert here I've read the project description and watched youtube video, and clearly understand your requirement I've completed several projects like this with 5 star rating, you can check my profile as More

$99 USD in 6 days
(73 Reviews)
6.1
bdoutsource

Dear sir, Greetings. I could make it more functional, automated where ever possible and create a stunning dashboard. Plz let me know if you are interested. Thank you.

$155 USD in 2 days
(104 Reviews)
6.1
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flaw I am very much able to work on this. ***I am ready to start More

$155 USD in 3 days
(45 Reviews)
5.6
JanviIndia

Hello there, Yes sure we can keep the existing data in the file but display it along with 3 new dashboard speedometer objects. I have reviewed your job post and would like to propose my interest in working for t More

$277 USD in 7 days
(3 Reviews)
4.8
TimHudspith

I have quite a bit of experience in making Excel reports and dashboards (about 8 years' worth in the banking world), usually pulling the data from a database such as SQL Server or Access. You don't mention where the da More

$250 USD in 10 days
(8 Reviews)
4.7
nimesha1994

Hi, I'm very interested to do your project. I have great knowledge on about your project. I have already read your description and I feel like I would be a great fit for the project. I can start your project right More

$35 USD in 2 days
(6 Reviews)
4.2
nevo1234

Dear sir, I am an expert in excel and also I am an economist (BA+MBA) by profession. The speedometer in that youtube is web based this is not so recomended to be used as can be an open door to your system for hacks More

$83 USD in 3 days
(12 Reviews)
4.2
CanadianQuality

Hi, Native English speaker. Excel/VBA expert. I can get this done for you quickly and elegantly. I have a lot of experience shaping data and creating dashboards. Do feel free to send me a chat request and I'd More

$222 USD in 3 days
(3 Reviews)
3.1
nagrahari

Hi , can you resend attachment, as i dont see it here I am an Engineer with 8 years or experience. And from last 8 years I am also working on Data Entry/ Excel. I feel I can call myself as an expert in Copy Typin More

$66 USD in 5 days
(3 Reviews)
2.0
asolodilov

Hello! I'll be glad to do your task, 'cause VBA projects is real joy for me, I think that everything that can be automized should be automized. By the way, you said about attached file, but I havent seen it, can you More

$100 USD in 3 days
(1 Review)
1.7
hwathsala

Hello Sir, About Me ------------------------- I am an experienced Developer from Sri Lanka with bachelor’s degree in computer science. currently working as, a SAP developer. In my free times I am doing part t More

$66 USD in 3 days
(2 Reviews)
1.5
ExcelPowerpoint

Hi I would be glad to assist you with this dashboard. I will create a professional dashboard with speedometers or any other charts as depicted in the video with drop-downs to change the data automatically as and wh More

$30 USD in 2 days
(1 Review)
0.3
srirampallapothu

I am very good at Excel macros using VBA. Some of the macros that I built include - Fetching data from Oracle tables into spreadsheet Consolidating multiple files into a single spreadsheet Read from multiple text d More

$160 USD in 3 days
(0 Reviews)
0.0
hermitchaka

A proposal has not yet been provided

$111 USD in 5 days
(0 Reviews)
0.0
suljan2016

I have lot of experience in using Excel. I have been building dashboards and I have been using Excel to build presentations. I am also particularly good with built-in functions and I can build Pivot tables. I have More

$150 USD in 5 days
(0 Reviews)
0.0