Find Jobs
Hire Freelancers

Excel Macro to compare data in two sheets

$10-30 USD

Completed
Posted about 1 year ago

$10-30 USD

Paid on delivery
Please see the attached file. I need you to create a Button in Sheet "Start" that compares data from Sheet1 and Sheet2 and then posts matching data in Sheet3. You can see data in Sheet1 and we are looking for the Name in Column G. Now we compare line 3 column G with the data in Sheet2 and see if the data in column F matches. We do this with every line from Sheet1 and go through ALL data in Sheet2. In the attached sample, line 10 of Sheet1 will produce a match as line 4, line 11 and line 18 of Sheet2 have the same info in Column F. Once a match is found I need all data from that line (in our example line 4, 11 and 18) copied to Sheet3. Every time I press the button this needs to happen, so before any copying is done, Sheet3 needs to be cleared of all entries and needs to be blank so we have a new set of data each time. This is an example, my final file will have thousands of lines, so it will need to do a lot of calculating. Ask me questions before you bid, so we both know we are on the same page. Post your price and do not start negotiating.
Project ID: 35820521

About the project

21 proposals
Remote project
Active 1 yr 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
$0 USD in 1 day
5.0 (73 reviews)
5.4
5.4
User Avatar
$0 USD in 1 day
4.9 (489 reviews)
6.8
6.8
21 freelancers are bidding on average $35 USD for this job
User Avatar
Update: Have check again and I think it possible to do within hours or two. It's easy job for me Hello, I have read project details and have check file. Think I can help with this project. Can do in short time. I have 16+ year experience in Excel, Excel VBA, Python and have 100% feedback You can trust, result will be excellent Best Regards
$25 USD in 1 day
5.0 (50 reviews)
4.9
4.9
User Avatar
Hello, I could help you Immediately with Excel Macro to compare data in two sheets, and will complete the work as per requirement ASAP. Also sample could be provided. I am a Data Scientist and Excel Expert. Have a wide range of technical competencies including: statistics, databases also collect, analyze, and interpret large data sets. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, drop-down boxes and charts. I create top-notch Excel solutions with VBA programming. I can automate Excel for you, and I’ll do that in the most professional way. I could help you out perfectly as soon as humanly possible. I am very interested in your offer. Have time to start immediately. Please send me a reply if you would like to talk more. I look forward to working with you! Kind Regards
$30 USD in 1 day
5.0 (14 reviews)
3.3
3.3
User Avatar
Hi I think I can help on your project. I have +20 years in programming in excel, using VBA. I've already started doing the project, I can delivery it to you in 15 minutes. Many thanks, José Machado
$15 USD in 1 day
5.0 (2 reviews)
3.0
3.0
User Avatar
Hello, I am an Excel expert and I would like to help you with your Data compare. I am fully available and I can start right away. Please check my profile and contact me to discuss. Best regards.
$20 USD in 1 day
5.0 (4 reviews)
3.2
3.2
User Avatar
Hello, This seems to be simple and straightforward task and can be delivered in a couple of hours. I don't have any questions related to the workflow, but does it need to be VBA? what about a python script? it will be more efficient/fast. I look forward to hearing from you to discuss this further.
$30 USD in 1 day
5.0 (3 reviews)
2.2
2.2
User Avatar
Hi, We are Remote Services. I can do this project. I can handle this sheet. I can prepare your sheet 3 in a proper way. Hope for your kind response, Regard
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Yo! I am interested in your project Excel Macro to compare data in two sheets I have completed similar papers in the past and can assure you of exceptional and original work within the agreed deadline. I have skills in Visual Basic, Data Entry, Visual Basic for Apps, Data Processing and Excel. please contact me to discuss your project in detail. Thanks & regards. Sep} Hey! I can help you with yourExcel Macro to compare data in two sheets at a high level! I have good experience in Visual Basic, Data Entry, Visual Basic for Apps, Data Processing and Excel. My skills and experience is a great match for your needs. Looking forward to hearing from you. Thank you.
$150 USD in 2 days
5.0 (1 review)
0.0
0.0
User Avatar
Hello there, Thanks for the job post,this is Joel Stewart from kenya, I have read your project description well and seems I am the best freelancer for this task for I an expert in Excel, Data entry, data processing, Visual Basic and visual basic for apps. I have over 5+ years solid experience in freelancer online writing therefore very much confident I will hit your expectations on time and as per your budgets. Waiting to hear from you so we discuss in details, Thanks, Joel.
$20 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I read your explanations. It's clear and I have no question and can do it tomorrow. Please send me message. Best Regards
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Dear i am MCSD and MS Office Certified Developer i can help you writing Excel Macro's Quickly & Perfectly. But i will charge little more if still interested do ping me.
$75 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've spent a lot of time with excel. I can process data for you using it, both as input and output. Additionally, I treat people fairly, but frequently do so by providing them with unreliable information among other things. Whatever your objective, I can automate the process for you to make your life simpler. Greetings, I'm looking forward to your letter!
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello ! I understand and i read your requirements so text me we will talk on it. I will do it please give me this project. I am expert in typing please give me this project. I will done it perfectly. I am expert in all your requirements.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am happy to take on this task for you. Have a lot of experience working on this sort of tasks including Photography, Web development and Cloud. Looking forward hearing from you. Mariusz Lewandowski
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I understand your need and I can help you facilitate your work. Contact me and we work together on this. it will be excellent
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Seabeck, United States
5.0
471
Payment method verified
Member since Nov 14, 2009

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.