Combine 2 Excel files using Excel Script / Macro / Lookups

Suljettu

Kuvaus

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

Projektin tunnus: #13791998

Myönnetty käyttäjälle:

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

17 freelanceria on tarjonnut keskimäärin 34 $ 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
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
expertatwork

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

30 $ AUD 1 päivässä
(181 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
17 $ AUD 0 päivässä
(0 arvostelua)
0.0
10 $ 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
30 $ AUD 1 päivässä
(0 arvostelua)
0.0