Find Jobs
Hire Freelancers

CREATE TOOL TO FIND DUPLICATES AND COPY DATA IN EXCEL

$10-30 AUD

Completed
Posted over 5 years ago

$10-30 AUD

Paid on delivery
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.
Project ID: 18376898

About the project

7 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 day
5.0 (3 reviews)
1.9
1.9
7 freelancers are bidding on average $51 AUD for this job
User Avatar
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 days
4.8 (72 reviews)
6.1
6.1
User Avatar
"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 day
5.0 (18 reviews)
4.4
4.4
User Avatar
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 day
5.0 (4 reviews)
1.9
1.9
User Avatar
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 day
5.0 (7 reviews)
1.8
1.8
User Avatar
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 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Miners Rest, Australia
5.0
16
Payment method verified
Member since Mar 15, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.