Find Jobs
Hire Freelancers

Create a production chart MACRO

$30-250 CAD

In Bearbeitung
Veröffentlicht vor etwa 8 Jahren

$30-250 CAD

Bezahlt bei Lieferung
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
Projekt-ID: 10250008

Über das Projekt

9 Vorschläge
Remote Projekt
Aktiv vor 8 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
9 Freelancer bieten im Durchschnitt $121 CAD für diesen Auftrag
Avatar des Nutzers
A proposal has not yet been provided
$200 CAD in 0 Tag
4,9 (249 Bewertungen)
7,0
7,0
Avatar des Nutzers
I can do it for you quickly and exactly
$100 CAD in 2 Tagen
4,9 (90 Bewertungen)
6,3
6,3
Avatar des Nutzers
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 Tagen
4,8 (72 Bewertungen)
5,8
5,8
Avatar des Nutzers
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 Tag
4,9 (28 Bewertungen)
4,9
4,9
Avatar des Nutzers
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 Tag
4,6 (14 Bewertungen)
3,9
3,9
Avatar des Nutzers
I can very work well with creating conditional formatting in user-defined macros, as well as mathematical equations.
$144 CAD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von CANADA
Scarborough, Canada
5,0
5
Zahlungsmethode verifiziert
Mitglied seit Feb. 10, 2016

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.