Find Jobs
Hire Freelancers

Create a production chart MACRO

$30-250 CAD

W trakcie realizacji
Opublikowano około 8 lat temu

$30-250 CAD

Płatne przy odbiorze
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
Identyfikator projektu: 10250008

Informację o projekcie

9 ofert
Zdalny projekt
Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
9 freelancerzy składają oferty o średniej wysokości $121 CAD dla tej pracy
Awatar Użytkownika
A proposal has not yet been provided
$200 CAD w 0 dzień
4,9 (249 opinii)
7,0
7,0
Awatar Użytkownika
I can do it for you quickly and exactly
$100 CAD w 2 dni
4,9 (90 opinii)
6,3
6,3
Awatar Użytkownika
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 w 3 dni
4,8 (72 opinii)
5,8
5,8
Awatar Użytkownika
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 w 1 dzień
4,9 (28 opinii)
4,9
4,9
Awatar Użytkownika
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 w 1 dzień
4,6 (14 opinii)
3,9
3,9
Awatar Użytkownika
I can very work well with creating conditional formatting in user-defined macros, as well as mathematical equations.
$144 CAD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 1 dzień
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga CANADA
Scarborough, Canada
5,0
5
Zweryfikowana metoda płatności
Członek od lut 10, 2016

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.