Find Jobs
Hire Freelancers

CREATE TOOL TO FIND DUPLICATES AND COPY DATA IN EXCEL

$10-30 AUD

Teljesítve
Kiadva ekkor: több mint 5 évvel ezelőtt

$10-30 AUD

Teljesítéskor fizetve
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.
Projektazonosító: 18376898

A projektről

7 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
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 1 napon belül
5,0 (3 értékelés)
1,9
1,9
7 szabadúszó adott átlagosan $51 AUD összegű árajánlatot erre a munkára
Felhasználó avatár
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 3 napon belül
4,8 (72 értékelés)
6,1
6,1
Felhasználó avatár
"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 1 napon belül
5,0 (18 értékelés)
4,4
4,4
Felhasználó avatár
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 1 napon belül
5,0 (4 értékelés)
1,9
1,9
Felhasználó avatár
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 0 napon belül
5,0 (7 értékelés)
1,8
1,8
Felhasználó avatár
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 5 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

AUSTRALIA zászlója
Miners Rest, Australia
5,0
16
Fizetési mód hitelesítve
Tagság kezdete: márc. 15, 2014

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.