Find Jobs
Hire Freelancers

Combine 2 Excel files using Excel Script / Macro / Lookups

$10-30 AUD

Terminado
Publicado hace casi 7 años

$10-30 AUD

Pagado a la entrega
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)
ID del proyecto: 13791998

Información sobre el proyecto

16 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
$30 AUD en 2 días
5,0 (1 comentario)
0,7
0,7
16 freelancers están ofertando un promedio de $35 AUD por este trabajo
Avatar del usuario
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 en 0 día
5,0 (440 comentarios)
7,4
7,4
Avatar del usuario
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 en 2 días
4,9 (127 comentarios)
6,5
6,5
Avatar del usuario
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 en 0 día
4,9 (63 comentarios)
6,1
6,1
Avatar del usuario
hello I can write this excel macro. please reply. thank you
$30 AUD en 1 día
4,8 (181 comentarios)
6,1
6,1
Avatar del usuario
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 en 1 día
4,9 (122 comentarios)
5,7
5,7
Avatar del usuario
- 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 en 0 día
5,0 (33 comentarios)
4,7
4,7
Avatar del usuario
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 en 1 día
5,0 (6 comentarios)
3,0
3,0
Avatar del usuario
$30 AUD en 1 día
5,0 (3 comentarios)
1,7
1,7

Sobre este cliente

Bandera de AUSTRALIA
Epping, Australia
5,0
25
Forma de pago verificada
Miembro desde ago 5, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.