Find Jobs
Hire Freelancers

Creating a macro in Excel

$10-30 CAD

In Bearbeitung
Veröffentlicht vor fast 9 Jahren

$10-30 CAD

Bezahlt bei Lieferung
I need a macro created for extracting, sorting and formatting data. There is a file attached for steps that I take manually to extract the information. I need the same steps created in a macro. Also attached is a raw data that you will be using to create the macro. This raw data is very simple, but the macro needs to be able to work with small and large amount of data. You will only get paid if the macro works. We will test the macro with various types of data and if it works then the payment will be issued.
Projekt-ID: 8267544

Über das Projekt

26 Vorschläge
Remote Projekt
Aktiv vor 9 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
26 Freelancer bieten im Durchschnitt $52 CAD für diesen Auftrag
Avatar des Nutzers
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
$120 CAD in 3 Tagen
5,0 (224 Bewertungen)
7,4
7,4
Avatar des Nutzers
A proposal has not yet been provided
$100 CAD in 1 Tag
4,9 (256 Bewertungen)
7,6
7,6
Avatar des Nutzers
I can do it for you quickly and exactly. . . .
$111 CAD in 3 Tagen
4,9 (115 Bewertungen)
7,0
7,0
Avatar des Nutzers
A proposal has not yet been provided
$30 CAD in 2 Tagen
4,9 (366 Bewertungen)
7,0
7,0
Avatar des Nutzers
A proposal has not yet been provided
$29 CAD in 2 Tagen
4,8 (221 Bewertungen)
7,1
7,1
Avatar des Nutzers
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 regards
$122 CAD in 3 Tagen
4,9 (241 Bewertungen)
7,0
7,0
Avatar des Nutzers
I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experiences over all the factors in your project.
$20 CAD in 1 Tag
5,0 (84 Bewertungen)
6,3
6,3
Avatar des Nutzers
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 flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
$24 CAD in 2 Tagen
4,7 (58 Bewertungen)
5,8
5,8
Avatar des Nutzers
I am willing to discuss further about the project details and deliver the same to your needs and specifications.
$44 CAD in 1 Tag
4,8 (25 Bewertungen)
5,5
5,5
Avatar des Nutzers
I have questions to ask as your document needs more explanation. Other than that, it seems easy. But if possible, I want to see the original data and work with it. Regards
$55 CAD in 1 Tag
5,0 (21 Bewertungen)
4,4
4,4
Avatar des Nutzers
Sir/Madam, Good day! I'm a degree holder and I'm an expert in excel/spreadsheet with experienced in vb in excel, vlookup, automated formulas, macro, HD charts and figures, etc. I'm also a virtual assistant for 3 years doing excel jobs. You will find me to be motivated and hardworking individual. Please contact me now. Thank you.
$25 CAD in 1 Tag
4,9 (2 Bewertungen)
3,3
3,3
Avatar des Nutzers
Hi, Please send a message so we can discuss your requirements. Also, I already have a file which does a similar job. I can send the sample file to you. Thanks, Chris
$45 CAD in 1 Tag
5,0 (9 Bewertungen)
3,3
3,3
Avatar des Nutzers
A proposal has not yet been provided
$25 CAD in 1 Tag
4,9 (6 Bewertungen)
2,9
2,9
Avatar des Nutzers
Hi! I checked your files, all is possible. I could do it in 1-2 days, but few days are necessary to check and to make adjustments if needed.
$30 CAD in 4 Tagen
5,0 (1 Bewertung)
0,8
0,8
Avatar des Nutzers
i'm working in data processing corp. as data editor, we frequently create macro to automate task, i'm an IT grad, knows VBA and visual basic
$77 CAD in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$25 CAD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I have done simular projects in my workplace. I optimized my own monthly reports, and I now do them for 15 minutes, instead of the 6 hours they took before automatization. Depending on the complexity of the macro, I can deliver much faster than 2 days. I am Excel proficient user. I use macros for more than 2 years. I have successfully completed projects, saving 5-6 manhours per run (on a report, executed every day). I do formatting macros, work with pivots, tables, file operations (splitting 1 sheet of data for different clients to separate files for all the clients, named with specific naming conventions), Outlook (meeting requests based on excel source, mailing distribution based on excel source). My most complex project is generating metrics report for 60-70 accounts, using different tools with different tool logic (hence metrics logic for each), which serves the managerial team of my unit with all information they need on the monthly performance. Manually (with standart excel features, including formulas and pivots), reporting all metrics would take more than a manmonth, due to the poorly structured data in the tools, we now do it in a day. I provide post-implementation support of the macros, if such is needed
$35 CAD in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi, I am an advanced excel user and I have the skill set to complete this task. In my previous role I created a number of macros for sorting and formatting large amounts of data so that it can presented in a more manageable way. Before getting started I would like to discuss the outcome that you are trying to achieve from the process that you have laid out. I understand that these are the steps you take when doing the process manually but sometimes there are better/faster/easier ways of achieving the same result with a macto. I see the final picture shows a table that is colour coded based on the results, but some understanding of what it is would greatly help. I believe I am an excellent candidate for this job and I am a native English speaker (originally from New Zealand and recently moved to Poland). I believe this is key to understanding the requirements of the job and ensuring that I provide you with what you need. Kind regards, Sam
$160 CAD in 6 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I have worked extensively with Excel, VBA, Financial Modelling and Dashboards. I enjoy creating files that are easy to use and re-use, give meaningful answers and assist with accurate decision making for business. I would be available to discuss this further if required.
$35 CAD in 4 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$50 CAD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von CANADA
Burlington, Canada
5,0
55
Zahlungsmethode verifiziert
Mitglied seit Aug. 26, 2014

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.