Find Jobs
Hire Freelancers

Combine 2 Excel files using Excel Script / Macro / Lookups

$10-30 AUD

Completed
Posted almost 7 years ago

$10-30 AUD

Paid on delivery
Create a Excel Macro, or script to combine 2 sheets of data into 1 final spreadsheet in the attached "Final" format. Lookup the "ArtNr" from [[login to view URL]] output the "Ztype" and "Note" if it is found in [[login to view URL]]. Please note of all the spacing and breaks in the [login to view URL] file. I have used colours to help understand the relationships, but this is not required in the final output. Source: [login to view URL] [login to view URL] Output: [login to view URL] This needs to be created in a way that I can run the script many times in the future and handle large volume of data. (100,000+ records)
Project ID: 13791998

About the project

16 proposals
Remote project
Active 7 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
Awarded to:
User Avatar
$30 AUD in 2 days
5.0 (1 review)
0.7
0.7
16 freelancers are bidding on average $35 AUD for this job
User Avatar
I use Excel vba tool to work on. But, i would like to know the number of rows. It may not fit one sheet. Hi, I am good at Excel and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra
$34 AUD in 0 day
5.0 (440 reviews)
7.4
7.4
User Avatar
ZERO ERROR GUARANTEED!! Please read my 190+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.
$100 AUD in 2 days
4.9 (127 reviews)
6.5
6.5
User Avatar
Hi I can quickly write for you code to combine files as you need and which will be usable for future use If interested, contact me Thanks & Regards I use VBA
$30 AUD in 0 day
4.9 (63 reviews)
6.1
6.1
User Avatar
hello I can write this excel macro. please reply. thank you
$30 AUD in 1 day
4.8 (181 reviews)
6.1
6.1
User Avatar
Hi , I have 10+ years of experience in Excel & VBA. Please check my past reviews and ratings. Please ping back to discuss the requirements , so that I can propose solution. Why i should be Hired ? I have very good experience 100% accurate solution 100% Time compliance Good Communication I am sincere,honest and hardworking independent freelancer. I give more importance to the job than $. Please let me know your email id for ease of communication . Thank You. Regards, Rishi
$25 AUD in 1 day
4.9 (122 reviews)
5.7
5.7
User Avatar
- Using the VBA scripting can get the lookup values for Artnr, Ztype and notes based on IDs. - 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.,
$30 AUD in 0 day
5.0 (33 reviews)
4.7
4.7
User Avatar
Hi. 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. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
$35 AUD in 1 day
5.0 (6 reviews)
3.0
3.0
User Avatar
$30 AUD in 1 day
5.0 (3 reviews)
1.7
1.7

About the client

Flag of AUSTRALIA
Epping, Australia
5.0
25
Payment method verified
Member since Aug 5, 2013

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.