Remote Data Mining And Management Job In Data Science And Analytics

Excel macro/VBA for matching data and outputting to new sheet

Find more Data Mining And Management remote jobs posted recently Worldwide

Hello everyone,

I have two CSV files with user data.

I would like an Excel macro that appears as a button in ribbon, which I can run on the two CSV files. The macro should run on Windows and Mac (Office 2016 version 16).

The flow should be like this:
- click match button
- select file 1
- select file 2
- select column header in file 1 to match
- select column header in file 2 to match
- click start
- see new sheet with all the rows which have matching data in the selected columns

I would like to complete this task this weekend, ideally today. I will be sifting applications over the next hour.

I will share CSVs to compare with shortlisted candidates.
About the recuiter
Member since Mar 14, 2020
Chandan Kumar
from Diyarbakir, Turkey

Skills & Expertise Required

Data Mining Excel VBA Microsoft Excel Visual Basic VBA

Open for hiringApply before - Oct 19, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.81

Cost

Offer to work on this project closes in 21 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

Graphic design for one-page certificate - Hourly
FULL-TIME - KILLER GRAPHIC DESIGNER NEEDED - Hourly
MQL4/Excel: Live indicators values in excel - Hourly
t shirt design, - Hourly
A DBA needed to clear a part of MongoDB database - Hourly
3D plant design with animation - Hourly
Need a English content writer - Hourly
Tradestation strategy automation - Fixed
Need website scraped for Contact Info - Fixed

Similar Projects

Sales Consultant

Looking for motivated Sales Consultant
Macheene is a Commerce/Customer Relationship Management company based in 14 different countries that offers its team members unlimited growth potential, an inelastic business, and high pay availability. read more

Excel expert Needed for Advanced NPV ROI IRR for Solar Project calculations

Im looking for an expert with google sheets. I need to create a sheet that links to another sheet that spits out the data without revealing the math. Its for a lead landing page..This is for the ROI of Solar power projects.. I actually have the cal...read more

Owners of Industrial Real Estate (Maple Grove)

Excel File including property address/ Property ID/ Company Owner/ Company Owner Address/ Company Owner Executive full name/ Company Owner Executive email/ Company Owner Phone number

Only 1.5+ acre lots
Only those located in Industrial Z...read more

Transferring specific data points from dynamic graphs/charts onto spreadsheet

Transferring data from website onto a spreadsheet similar to the File, which needs to be cleaned up an organized. it provides charts and graphs, but no reports, so specific monthly numbers needs to be transcribed onto the spread.

Looking at...read more

Need help for Google Sheets

There are 4 jobs which I will share a video link with shortlisted candidates

Job 1: Automatically add timestamp (that wont be overwritten) in column C when column M is filled Job 2: Automatically add timestamp (that wont be overwritten) in...read more