Find Jobs
Hire Freelancers

Add Macros to Excel Spreadsheet / Dashboard

$30-250 AUD

In Progress
Posted about 12 years ago

$30-250 AUD

Paid on delivery
Job: Add macros and formulas to Excel Spreadsheet so that the dashboard updates automatically when drop down menu selects new date range. Tasks: 1. Add four columns of formulas linked to worksheet data to be created: a. Current month b. Week on week variance ie. Current month - Last month (+/-) c. Last 4 weeks average ie. Curent month + Last 3 months / 4 d. Last 12 weeks average ie. Current month + 11 months / 12 2. Add macro to charts up so they update automatically Attached is an example of how it works including formulas. I would like this functionality copied on to the Dashboard.
Project ID: 1491754

About the project

8 proposals
Remote project
Active 12 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 am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years.I have viewed both of your attachments, you can do without macro, but I can do both ways. More in PM, please.
$40 AUD in 2 days
4.7 (13 reviews)
3.8
3.8
8 freelancers are bidding on average $84 AUD for this job
User Avatar
Consider it done. Check your PM.
$150 AUD in 3 days
4.9 (49 reviews)
5.2
5.2
User Avatar
I can provide the required macros in Excel VBA.
$45 AUD in 3 days
4.8 (30 reviews)
4.4
4.4
User Avatar
Please see my PM.
$50 AUD in 5 days
4.7 (4 reviews)
3.8
3.8
User Avatar
I can provide you with the macros needed. Regards, Mike
$130 AUD in 15 days
5.0 (9 reviews)
3.6
3.6
User Avatar
Sir, I have good experience. Your topic is easy!
$40 AUD in 4 days
5.0 (2 reviews)
1.0
1.0
User Avatar
This is very interesting, and the Excel is well built. I'd like very much to do it. You can check my references on Elance (P. Vaz, from portugal).
$120 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 20 years experience in excel, the last 10 of which included writing complex macros and improving automation. Please see my profile for more background. Thank you, Andrew Stanhope
$100 AUD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
1
Payment method verified
Member since Mar 8, 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.