Find Jobs
Hire Freelancers

CREATE TOOL TO FIND DUPLICATES AND COPY DATA IN EXCEL

$10-30 AUD

Terminado
Publicado hace más de 5 años

$10-30 AUD

Pagado a la entrega
I have an Excel workbook as per uploaded. I require a tool – either external to the workbook or built into the workbook – that will do the following. Look for duplicate entries on 2 sheets – NEW 2 TURNS and VIC WATCHDOG by searching and finding duplicates in columns A and column H. As an example, this tool would find the name (column A) PERFECT HOURS and the date (column H) 14-Dec-18 on both sheets. Once each duplicate has been identified, I want some data from the VIC WATCHDOG sheet to be copied to the NEW 2 TURNS sheet. The data for each duplicate line to be copied is the following columns: Column K Column L Column M Column U Column V Column W Column Y Sometimes the data in these columns on the VIC WATCHDOG will be blank, just want all those columns pasted over to NEW 2 TURNS sheet for any duplicate record when matched by Col A (NAME) and Col H (DATE). I have attached a small sample of data - please prepare a sample of the tool and results so I can see how it will work before awarding project. PLEASE NOTE - the uploaded file is only a small sample of data, the tool will need to work in a workbook with full data and with other sheets in the workbook.
ID del proyecto: 18376898

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 5 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
Hi there, I have been coding VBA automation tools that help enable the quicker and error-free production of MI for end users since 2009. This is a simple project for me. Please see my case studies and website FD4Cast for more information. Many thanks, James
$30 AUD en 1 día
5,0 (3 comentarios)
1,9
1,9
7 freelancers están ofertando un promedio de $51 AUD por este trabajo
Avatar del usuario
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$100 AUD en 3 días
4,8 (72 comentarios)
6,1
6,1
Avatar del usuario
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$30 AUD en 1 día
5,0 (18 comentarios)
4,4
4,4
Avatar del usuario
Hello sir, I hope you are having a good day. I can create a macro code to find duplicates and fill up information in respected columns. I can first create the file and then we will proceed to order. Looking forward to hear from you soon. Regards aftabahmad1994
$30 AUD en 1 día
5,0 (4 comentarios)
1,9
1,9
Avatar del usuario
Hi I can do your project using ActiveData for Excel which is a powerful excel tool. It will give you the results needed but you won't be able to use it at other project because it will give you directly the results. Otherwise, I can do formulas for you so you can use it at other projects. It is up to you to chose. Waiting to hear from you :) Regards,
$19 AUD en 0 día
5,0 (7 comentarios)
1,8
1,8
Avatar del usuario
Hi There, I can give you software solution in which you can do comparison of data and manipulation as well. Looking forward Thanks.
$100 AUD en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Miners Rest, Australia
5,0
16
Forma de pago verificada
Miembro desde mar 15, 2014

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.