Find Jobs
Hire Freelancers

CREATE TOOL TO FIND DUPLICATES AND COPY DATA IN EXCEL

$10-30 AUD

Completato
Pubblicato più di 5 anni fa

$10-30 AUD

Pagato al completamento
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.
Rif. progetto: 18376898

Info sul progetto

7 proposte
Progetto a distanza
Attivo 5 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 in 1 giorno
5,0 (3 valutazioni)
1,9
1,9
7 freelance hanno fatto un'offerta media di $51 AUD
Avatar dell'utente
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 in 3 giorni
4,8 (72 valutazioni)
6,1
6,1
Avatar dell'utente
"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 in 1 giorno
5,0 (18 valutazioni)
4,4
4,4
Avatar dell'utente
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 in 1 giorno
5,0 (4 valutazioni)
1,9
1,9
Avatar dell'utente
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 in 0 giorno
5,0 (7 valutazioni)
1,8
1,8
Avatar dell'utente
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 in 5 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: AUSTRALIA
Miners Rest, Australia
5,0
16
Metodo di pagamento verificato
Membro dal mar 15, 2014

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.