Käynnissä

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.

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)

Taidot: Excel, Javascript, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: excel run extern macro, vba excel run script, excel macro module script, combine files excel, excel macro compare script, excel macro perl script, combine data excel files, using dat files excel, excel macro name script

About the Employer:
( 24 reviews ) Epping, Australia

Projektin tunnus: #13791998

Myönnetty käyttäjälle:

30 $ AUD 2 päivässä
(1 arvostelu)
0.7

16 freelanceria on tarjonnut keskimäärin 35 $ tähän työhön

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 Lisää

34 $ AUD 0 päivässä
(440 arvostelua)
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 Lisää

100 $ AUD 2 päivässä
(127 arvostelua)
6.5
expertatwork

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

30 $ AUD 1 päivässä
(181 arvostelua)
6.1
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 0 päivässä
(63 arvostelua)
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 Lisää

25 $ AUD 1 päivässä
(122 arvostelua)
5.7
55 $ AUD 1 päivässä
(50 arvostelua)
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 Lisää

30 $ AUD 0 päivässä
(33 arvostelua)
4.7
30 $ AUD 2 päivässä
(27 arvostelua)
4.4
25 $ AUD 0 päivässä
(17 arvostelua)
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 Lisää

35 $ AUD 1 päivässä
(6 arvostelua)
3.0
30 $ AUD 1 päivässä
(3 arvostelua)
1.7
35 $ AUD 1 päivässä
(1 arvostelu)
0.8
30 $ AUD 1 päivässä
(0 arvostelua)
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 Lisää

50 $ AUD 1 päivässä
(0 arvostelua)
0.0
10 $ AUD 1 päivässä
(0 arvostelua)
0.0
17 $ AUD 0 päivässä
(0 arvostelua)
0.0
30 $ AUD 1 päivässä
(0 arvostelua)
0.0