Find Jobs
Hire Freelancers

Write a Excel Macro to convert two input files to 1 output

$10-15 USD

Cancelled
Posted about 6 years ago

$10-15 USD

Paid on delivery
This project is for one Excel Macros: This will be run daily/weekly The Macro will convert a 1 .CSV with data and 1 .XLXS that will be used as a lookup and convert the output to 1. CSV. The format of the two input files will always remain the same, format/template, however, the data in the file will always be different.
Project ID: 16571352

About the project

32 proposals
Remote project
Active 6 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
32 freelancers are bidding on average $18 USD for this job
User Avatar
Hi there..... Warm Greetings We came along with your request for Write a Excel Macro to convert two input files to 1 output and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic for Apps We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$30 USD in 1 day
4.9 (400 reviews)
8.1
8.1
User Avatar
Hello It looks as easy task - can you send sample of input files and output file? Thanks.
$15 USD in 3 days
4.9 (395 reviews)
6.6
6.6
User Avatar
I am proficient in using excel macro/VBA, I can write the code to generate new csv after lookup, await for your precious reply to discuss the detail to start.
$15 USD in 10 days
5.0 (125 reviews)
6.5
6.5
User Avatar
hi there! i am python expert i can write code in python that you want in excel Macro, if agree, lets talk more in chat regards!
$15 USD in 10 days
5.0 (14 reviews)
5.9
5.9
User Avatar
- Can get the data from the CSV and compare with the second xlsx sheet as the lookup and consolidate the final output as the CSV. - On button click the output can be generated. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Pl. review my portfolio on recent projects.
$20 USD in 0 day
4.6 (51 reviews)
6.1
6.1
User Avatar
I have the expertise in Excel Macros and have experience in writing similar macros. Ready to start work immediately.
$17 USD in 1 day
4.6 (67 reviews)
5.4
5.4
User Avatar
A proposal has not yet been provided
$17 USD in 1 day
4.9 (26 reviews)
4.9
4.9
User Avatar
What type of data on the csv are we checking against the xlxs file? The best way to do this would be to open the xlxs file, open the csv, use a vlookup or similar function to obtain whatever you want from the csv using the xlxs, and then create and convert a new file with the output into csv. Since the input and output formats would always be the same the function that would compare both sheets wouldn't be very hard although the creation and organization of both file types might be. Tell me what you think.
$15 USD in 3 days
5.0 (13 reviews)
3.8
3.8
User Avatar
Hi. Please see my profile for samples. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle
$20 USD in 1 day
4.4 (20 reviews)
3.9
3.9
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
5.0 (3 reviews)
2.8
2.8
User Avatar
Hello, I would like to know additional details about your project. Can you provide a sample of the input files and the format for the final output finale? You can check my previous work, including Excel macros, on my portfolio here on freelancer. Best regards, Madalina
$20 USD in 5 days
5.0 (2 reviews)
1.3
1.3
User Avatar
Dear Sir / Madam I have been doing similar sort of work for quiet sometime now, you have have your work delivered to you within no time swiftly and error free as per your requirement. Regards Shahzaib Khan
$10 USD in 0 day
5.0 (2 reviews)
0.8
0.8
User Avatar
I possess 7 years of experience in the field of Indian Accounting & Auditing, taxes & financial Reports & statements. I have a good amount of knowledge in GST return preparation. Additionally I am good in Microsoft Excel, word, PowerPoint presentation Etc.
$16 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir/madam, My name is Asiri Weerakoon from Sri Lanka. I Studied your project, understood all your requirements and therefore I am bidding for it. I am an experienced Accounts assistant, with a creative mind that captures clients imaginations and transforms it into my canvas. you can view my portfolio in my profile for being sure. I assure you that you all get exactly the same as the end results as you have in your mind right now in the given time frame or even before that. I'm interested in working with you on this project and we can work future projects. if want to see more of my work or if you have any questions in mind you can message me anytime. Thank you and have a nice day. Hoping for a positive reply for you, All the best though for the project. Regards, Asiri Weerakoon.
$10 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Happy to help you on merging the data with excel macros. Could you please provide the sample data formats
$17 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$17 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can complete this project in given time with unmatched quality. Have a great day ahead Regards, Anshuman jha
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Toronto, Canada
5.0
18
Payment method verified
Member since Feb 26, 2014

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.