Combine 2 Excel files using Excel Script / Macro / Lookups

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.


[url removed, login to view]

[url removed, login to view]


[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)

Habilidades: Excel, Javascript, PHP, Arquitetura de software

Veja mais: 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

Acerca do Empregador:
( 25 comentários ) Epping, Australia

ID do Projeto: #13791998

Concedido a:

$30 AUD em 2 dias
(1 Comentário)

16 freelancers estão ofertando em média $35 para esse trabalho


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 Mais

$34 AUD in 0 dias
(440 Comentários)

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 Mais

$100 AUD in 2 dias
(127 Comentários)

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

$30 AUD em 1 dia
(181 Comentários)

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 dias
(63 Comentários)

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 Mais

$25 AUD em 1 dia
(122 Comentários)
$55 AUD em 1 dia
(50 Comentários)

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

$30 AUD in 0 dias
(33 Comentários)
$30 AUD in 2 dias
(27 Comentários)
$25 AUD in 0 dias
(17 Comentários)

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 Mais

$35 AUD em 1 dia
(6 Comentários)
$30 AUD em 1 dia
(3 Comentários)
$35 AUD em 1 dia
(1 Comentário)
$30 AUD em 1 dia
(0 Comentários)

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 Mais

$50 AUD em 1 dia
(0 Comentários)
$10 AUD em 1 dia
(0 Comentários)
$17 AUD in 0 dias
(0 Comentários)
$30 AUD em 1 dia
(0 Comentários)