Find Jobs
Hire Freelancers

Create a production chart MACRO

$30-250 CAD

In Progress
Posted almost 8 years ago

$30-250 CAD

Paid on delivery
Hi, I need a MACRO that I will be able to use on any computer (so you may need to create a button) This excel file has TWO Tabs, the first tab is the raw data. This is the report I get when I download it and it will always remain the same. STEP 1 : There are two columns highlighted in BLUE Labelled SALE and SALE2. You need to to first add these columns together Step 2: The macro needs to add SALE and SALE 2 together and labelled it SALES and then delete all the other columns that are not green or your new variable called SALES Step 3: Then create a column called FLOW. to get the flow we divide SALES BY TIME (you need to create a formula that can handle this or USE =(E6/(VALUE(D6)*24)) Step 4: Add another column named feedback and use a (+) in green or (-) for anyone who is above the required flow or under it. (-) means under and (+) means the same or under Step 5: Use conditional formatting on the Sales (where the highest sales is highlighted in green) Step 6: Use conditional formatting on the FLOW where the highest flow is highlighted in green) Let me know if you need anymore advice .Need it for tonight
Project ID: 10250008

About the project

9 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
9 freelancers are bidding on average $121 CAD for this job
User Avatar
A proposal has not yet been provided
$200 CAD in 0 day
4.9 (249 reviews)
7.0
7.0
User Avatar
I can do it for you quickly and exactly
$100 CAD in 2 days
4.9 (90 reviews)
6.3
6.3
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping, VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$147 CAD in 3 days
4.8 (72 reviews)
5.8
5.8
User Avatar
I am a Chartered Accountancy student providing an array of services relating to Microsoft office with Excel and word being my area of expertise . I have been providing troubleshooting on macros for other clients and have got great reviews for the same. I can start today and provide the output by the end of day.
$100 CAD in 1 day
4.9 (28 reviews)
4.9
4.9
User Avatar
I am a postgraduate in finance (MBA) with more than 5 years of experience having expertise in Excel, VBA. Currently working in an MNC Analytical company on a large financial model including macros for dashboards and presentation, for a leading US bank. I can help you with your current requirement as well as any further requirement with low cost of work. I can deliver the work in lesser time than others while maintaining the superior quality of work.
$70 CAD in 1 day
4.6 (14 reviews)
3.9
3.9
User Avatar
I can very work well with creating conditional formatting in user-defined macros, as well as mathematical equations.
$144 CAD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am able to do this job with all the requirements you said, and i am able to do it fast. I have already made a lot of plans using VBA (macro) and even small "systems". And you have also gave one example of the plans that you are going to use (the model). So, this is not going to be difficult to do. Only one question. When you said "it will always remain the same", does it means that every time the columns number and its titles will not change? If this is true, then the work should be a little bit easier.
$35 CAD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Scarborough, Canada
5.0
5
Payment method verified
Member since Feb 10, 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.