Find Jobs
Hire Freelancers

Build Excel macros that can format 3 sets of spreadsheets (2 in each set) and produce new files that match specifications

$250-750 USD

Abgeschlossen
Veröffentlicht vor etwa 9 Jahren

$250-750 USD

Bezahlt bei Lieferung
I need three different macros built into a blank spreadsheet or 3 separate spreadsheets if that's not possible. Each macro will have a way to select a file from my computer, format the file based on my specifications, and produce a new version of the file that is saved to the same folder directory. The new file will have the same file name as the original plus the word "FORMATTED" appended to the filename. Macro 1 Instructions on how to format the files are provided in file named "CD1_A Form [login to view URL]". The macro will format the original files, named [login to view URL] AND [login to view URL], and produce a file that looks like the final product, which are files named [login to view URL] AND [login to view URL] Macro 2 Instructions on how to format the files are provided in file named "CD3_B Form [login to view URL]". The macro will format the original files, named [login to view URL] AND [login to view URL], and produce a file that looks like the final product, which are files named [login to view URL] AND [login to view URL] Macro 3 Instructions on how to format the files are provided in file named "CD3_C Form [login to view URL]". The macro will format the original files, named [login to view URL] AND [login to view URL], and produce a file that looks like the final product, which are files named [login to view URL] AND [login to view URL]
Projekt-ID: 7127792

Über das Projekt

32 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
Vergeben an:
Avatar des Nutzers
Hi, I'll be happy to help you with this project. Please feel free to message me if you need to discuss any questions
$275 USD in 3 Tagen
4,9 (257 Bewertungen)
7,7
7,7
32 Freelancer bieten im Durchschnitt $321 USD für diesen Auftrag
Avatar des Nutzers
Hello! I'm an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$300 USD in 2 Tagen
5,0 (492 Bewertungen)
8,0
8,0
Avatar des Nutzers
Hi ! I work at international bank as credit analyst, so i work a lot with raw data. I can make this macro asap, and as new on this site, i"ll make it for low price. Regards, Vlad Zinchenko
$277 USD in 3 Tagen
5,0 (67 Bewertungen)
7,7
7,7
Avatar des Nutzers
Hi, I can do this job for you. I had done many similar jobs already. It can be done very quickly. Regards, programmer Aleks
$250 USD in 1 Tag
5,0 (89 Bewertungen)
6,2
6,2
Avatar des Nutzers
A proposal has not yet been provided
$250 USD in 3 Tagen
5,0 (142 Bewertungen)
5,4
5,4
Avatar des Nutzers
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering the usual Open file dialog or a Control form containing information necessary to identify the current input and output files. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$250 USD in 3 Tagen
4,9 (64 Bewertungen)
5,7
5,7
Avatar des Nutzers
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. But I joined this site just a month ago. Within a month I won two of tough contests held on this site. This says a lot about the quality of my services. I have worked on lot of advance excel dash boarding and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$500 USD in 5 Tagen
4,9 (19 Bewertungen)
5,7
5,7
Avatar des Nutzers
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards
$333 USD in 5 Tagen
4,6 (45 Bewertungen)
5,6
5,6
Avatar des Nutzers
See my portfolio and reviews, contact me if you're interested. Thanks____________________________________
$300 USD in 5 Tagen
4,9 (34 Bewertungen)
5,3
5,3
Avatar des Nutzers
Dear, Regarding my qualifications, I hold a Master's degree in Electrical Power Systems and a Bachelor's degree in Engineering (Electrical) and I've been using Matlab/Excel/VBA for 5+ years. Regarding The project: Please more info in PM if you are interested. Thank you. :) I await your reply. With Kind Regards Boris
$400 USD in 7 Tagen
4,9 (28 Bewertungen)
5,3
5,3
Avatar des Nutzers
HI I am an excel-vba Expert and I can will finish your project so fast pm me ,,,,,,,,,,,,,we can discuss on the price too :) I am ready to start now pm me ................................................................
$250 USD in 5 Tagen
5,0 (38 Bewertungen)
5,3
5,3
Avatar des Nutzers
I have completed several projects like this one. I am working as consultant for an insurance company and I have completed many projects like this one. Reading CSV files, connecting them, is what I do.
$250 USD in 2 Tagen
5,0 (25 Bewertungen)
4,6
4,6
Avatar des Nutzers
Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$277 USD in 5 Tagen
5,0 (54 Bewertungen)
4,7
4,7
Avatar des Nutzers
A proposal has not yet been provided
$555 USD in 10 Tagen
4,9 (22 Bewertungen)
4,2
4,2
Avatar des Nutzers
I have over 9 years of experience in Excel, Access and Outlook VBA. I have developed several Tools, Automation, Dashboard, Database CRM and Online Extraction Tools using VBA. I have done a similar kind of project for one of my clients using VBA in outlook
$277 USD in 10 Tagen
4,9 (14 Bewertungen)
4,1
4,1
Avatar des Nutzers
If only all employers had your level of articulating requirements! My proposition: 3 macros in one file, a small dashboard where you can specify folders if they are fixed or open a filedialog window for you to select one. Processing the csvs as per your requirements and producing a FORMATTED output. I have worked with Excel, csv, data manipulation, ETL for the last 8 years. I can deliver the output on time and with high quality. I also care about the aesthetic side of the solution. Let me know if you'd like to proceed Once again - great instructions in PDF! Thanks! Not a difficult project but a little bit time consuming and requiring attention to detail Regards Morris
$300 USD in 4 Tagen
4,9 (7 Bewertungen)
3,6
3,6
Avatar des Nutzers
a b c f g f g f g fg d g d g g d f g g f d d f f g f fr r e e d fg g g g f f f f f df d d d d d d d d d d d d d d d d d
$555 USD in 10 Tagen
5,0 (3 Bewertungen)
2,3
2,3
Avatar des Nutzers
Good day, I can write these three macros for you which will format the original files in accordance with your specifications.
$250 USD in 3 Tagen
3,7 (5 Bewertungen)
2,8
2,8
Avatar des Nutzers
hello employer i have exp of handling csv files programatically i can provide you the complete work in 1 day time i can do this task for around $150 plz message me for further communication
$250 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Sir, I've already completed your project. If you award the bid I'll upload the workbook to you as soon as I can (within 8 hours of receiving your message). I expect you'll find no defects, but if you do I'll fix them ASAP. Completing the project before the bid is awarded may not be very smart. However I'm eager to build a positive reputation here. I create VBA macros for format conversions all the time. I am very good at it, and FAST. I also have experience creating file picker dialogues, for selecting the target CSV files on your computer. I frequently complete similar projects in just a couple of hours. My proposal is to create a single, easy to use Excel workbook. It will contain a single sheet, with one button. When that button is clicked, it will open a file picker dialogue, asking you to select the folder that contains the original CSV files. Once you hit OK, it will convert the formatting and save the formatted CSVs back to the original file location. This one workbook will contain all of the macros.
$333 USD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
$277 USD in 7 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED STATES
Austin, United States
5,0
3
Zahlungsmethode verifiziert
Mitglied seit Feb. 10, 2013

Kundenüberprüfung

Andere Aufträge von diesem Kunden

Responsive email template
$30-250 USD
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.