Find Jobs
Hire Freelancers

Delete Non Matching Rows in Excel Using Existing Macro

$10-30 USD

Completed
Posted over 5 years ago

$10-30 USD

Paid on delivery
I need to enhance an Excel Macro that I am already using. Currently I use a macro where sheet 1 is a very long list and sheet 2 is a much smaller list. The macro compares sheet 2 against sheet 1 and will delete rows in sheet 1 where there is not a match in column A in sheet 2. I found my existing Macro here: [login to view URL] I now need the Excel macro to evaluate TWO values from sheet 2. The macro now needs to evaluate column A and column D on sheet 2 and compare these same values that will reside in the same columns in sheet 1. If there is not a exact match for both records in sheet 1 then the entire row gets deleted. I am uploading an example Excel enabled macro workbook with the Macro that I currently use with some sample data. I have colored the rows yellow, blue and some rows have no colors. Currently the macro will remove the non colored rows only and keep the yellow and blue rows. You can run the macro and see how it works. I need the enhanced macro to delete non colored rows AND delete the yellow rows while only keeping the blue rows in sheet 1. You will notice the blue colored rows in sheet 1 are an exact match to sheet 2.
Project ID: 18425027

About the project

8 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, developing a macro for removing specific lines based on specific criteria between two sheets is pretty simple. I've done similar macros (VBA) before without a problem. If you are interested feel free to message me, so we can go over it together. I am currently reviewing your attached file. Edit: I've reviewed the file, this is definitely possible, and i can develop it, under an hour. Thanks, Milan
$15 USD in 0 day
5.0 (18 reviews)
4.8
4.8
8 freelancers are bidding on average $24 USD for this job
User Avatar
I am proficient with Microsoft excel and macro/VBA development, I am confident I can deliver an excellent result in a short turnaround timescale as depicted in your description - delete non matching rows. You’re welcome to checkout my reviews and project completion rate, feel free to message me if you have any questions. I am available to start your project immediately, looking forward to chat further and work on your project.
$30 USD in 1 day
5.0 (16 reviews)
3.7
3.7
User Avatar
I have knowledge in macros and avdanced microsoft excel operations and programming. I can do this job
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
My work is to make robust system in excel VBA for bridge designing. I am working with VBA Macro from 2 years so it would be very relevant work to do with ease.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have just completed my ms excel certifcation course in MS excel. i'll be able to help you to achieve you the goal as i am fresh with the excel basics.
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Expertise of excel macro Did so many projects similar to yours Working on it till you %100 satisfied Taught and use excel/macro over 15 years PhD: Quantitative Methods, Business School
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Tucson, United States
5.0
8
Payment method verified
Member since Dec 22, 2007

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.