Combine 2 Excel files using Excel Script / Macro / Lookups

$10-30 AUD

Ολοκληρώθηκε

Αναρτήθηκε

περίπου 7 χρόνια πριν

$10-30 AUD

Πληρωμή κατά την παράδοση

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)

Excel

JavaScript

PHP

Software Architecture

Ταυτότητα εργασίας: 13791998

Σχετικά με την εργασία

16 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@kahartle

$30 AUD σε 2 ημέρες

5,0

(1 αξιολόγηση)

0,7

16 freelancers δίνουν μια μέση προσφορά $35 AUD για αυτή τη δουλειά

@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 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 σε 0 ημέρα

5,0

(440 αξιολογήσεις)

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 satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.

$100 AUD σε 2 ημέρες

4,9

(127 αξιολογήσεις)

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 ημέρα

4,9

(63 αξιολογήσεις)

6,1

@expertatwork

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

$30 AUD σε 1 ημέρα

4,8

(181 αξιολογήσεις)

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 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 σε 1 ημέρα

4,9

(122 αξιολογήσεις)

5,7

@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 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 σε 0 ημέρα

5,0

(33 αξιολογήσεις)

4,7

@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, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now

$35 AUD σε 1 ημέρα