Combine 2 Excel files using Excel Script / Macro / Lookups

Closed

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 [[url removed, login to view]] output the "Ztype" and "Note" if it is found in [[url removed, login to view]]. Please note of all the spacing and breaks in the [url removed, login to view] file.

I have used colours to help understand the relationships, but this is not required in the final output.

Source:

[url removed, login to view]

[url removed, login to view]

Output:

[url removed, login to view]

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)

Skills: Excel, Javascript, PHP, Software Architecture

See more: excel macro visual basic download combine multiple files tabdelimited single column files, script create user files excel, call excel macro perl script, import multiple csv files excel macro, excel run extern macro, vba excel run script, excel macro module script, import multiple text files excel macro, combine files excel, excel macro compare script, importing text files excel using visual basic, excel script generate text files cells, excel macro perl script, combine data excel files, converting dat files excel files using net, using dat files excel, excel macro name script

Project ID: #13791998

Awarded to:

$30 AUD in 2 days
(1 Review)
0.7

16 freelancers are bidding on average $35 for this job

cgullapalli

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 More

$34 AUD in 0 days
(440 Reviews)
7.4
KulfiSoftwares

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 satisfie More

$100 AUD in 2 days
(127 Reviews)
6.5
sandroshubladze

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 days
(63 Reviews)
6.1
expertatwork

hello I can write this excel macro. please reply. thank you

$30 AUD in 1 day
(181 Reviews)
6.1
rengrish

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 More

$25 AUD in 1 day
(122 Reviews)
5.7
$55 AUD in 1 day
(50 Reviews)
5.4
satishtl

- 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 More

$30 AUD in 0 days
(33 Reviews)
4.7
$30 AUD in 2 days
(27 Reviews)
4.4
$25 AUD in 0 days
(17 Reviews)
4.0
huongth

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, fo More

$35 AUD in 1 day
(6 Reviews)
3.0
$30 AUD in 1 day
(3 Reviews)
1.7
$35 AUD in 1 day
(1 Review)
0.8
$30 AUD in 1 day
(0 Reviews)
0.0
$17 AUD in 0 days
(0 Reviews)
0.0
$10 AUD in 1 day
(0 Reviews)
0.0
Dadul

RESUME Experience :- Total 6 Years in IT field. Last 4 years in PHP, MySQL, Laravel Sr. PHP/wordpress/joomla Developer / Team Leader / Project Leader (LAMP / WAMP) Skill Set Scripting Language PHP, Laravel Wordp More

$50 AUD in 1 day
(0 Reviews)
0.0
$30 AUD in 1 day
(0 Reviews)
0.0