Find Jobs
Hire Freelancers

VBA Excel Macro

$10-30 USD

Completed
Posted over 6 years ago

$10-30 USD

Paid on delivery
Need VBA macro that iterates through range in primary sheet and finds all occurrences of itself in a secondary sheet. For every match, the macro must construct a comma separated & alphabetically ordered list of matches and append it to the same row of matched cell on the primary sheet. For example, per the attached VBA SAMPLE TEMPLATE The master sheet is named MASTER (it contains no duplicates) The secondary sheet is named SECONDARY (it contains many duplicates) The macro follows this logic Starting from the master sheet, it iterates among ever row in the sheet. It gets the value in column B named “ThumbrintLookup”. That value is searched in every row of column B in the secondary sheet For every find, match, it collects the value in column A named “Key” from the secondary sheet It puts the value in column D of the primary sheet It continues to build a comma separated string/list of matches After no matches are found for the processed row, the macro continues to process the next row Notice that column C named count in the primary sheet reports the number of matches that ThumbprintLookup appears in the secondary sheet Therefore the quantity of comma separated strings matched in the secondary sheet MUST match the count value specified in column C of the primary sheet ........................... This is a 10 minute job for a VBA specialist. Keep it simple, scalable and document your code. If proven, we can do more advance work in the future. That's why this is a very low budget project to demo what you know. $10 Max Don't bid for my maximum. I'll review proposals that have the keyword VBAROCKS in their bid :)
Project ID: 15070189

About the project

5 proposals
Remote project
Active 7 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
Lets start with keyword VBAROCKS. Anyway, i can definitely automate this, it will take little more than 10 minutes, because i need to sort it alphabetically. Relevant Skills and Experience Excel, VBA, Macros, Data Processing. I m serious freelancer with 100% completion rate and i've completed hundreds of excel projects without having a single problem. Proposed Milestones $10 USD - For complete work If you are interested in working with me, just message me and i will start immediately.
$10 USD in 0 day
5.0 (21 reviews)
4.8
4.8
5 freelancers are bidding on average $15 USD for this job
User Avatar
VBAROCKS : I have 11+ years of experience with various project exposure. I hope I can do this one. Relevant Skills and Experience VBA Proposed Milestones $30 USD - final payment
$15 USD in 1 day
4.9 (14 reviews)
4.5
4.5
User Avatar
VBAROCKS Dear Hiring Manager, I have read the project description and would like to work on it. I am a professional with 10 years experience and have recently closed 4 projects in excel using macros. Looking forward to hear from you. Regards Chintu
$10 USD in 1 day
5.0 (4 reviews)
2.8
2.8
User Avatar
I have data analytics experience i can do this job of yours. As u said i m only charging u $10 for this extra $5 is freelancer fees.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm a VBA programmer with 10 years of experience in it.. Relevant Skills and Experience VBA, User friendly design, Scalable design
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Bellevue, United States
5.0
28
Payment method verified
Member since May 8, 2011

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.