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
Gaurav Bhagrath
from Souss-Massa, Morocco

Skills & Expertise Required

Data Mining Excel VBA Microsoft Excel Visual Basic VBA 
Candidate shortlisted and hiredHiring open till - Oct 15, 2022

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$34.78

Cost

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

Nginx PHP-FPM Configuration Help needed for Magento 2 - Fixed
Python developer needed to collect online data - Hourly
Facebook Pixel / Tag Manager Installation - for Facebook Travel Catalogs - Hourly
ASP.net Developer Needed to create an API ASAP!! - Fixed
Need developer to integrate Odoo to Active Campaign via API connection. - Fixed
PCI DSS-PA Certification process and procedures - Hourly
BWVP Direct Mail Campaign - Hourly
To Do List - needed asap - Fixed
Scrape website - Fixed
Single Family residence - architect/designer needed - Fixed
Custom illustrations for blog & marketing - Hourly
Structural Engineer needed for Live Oak condo in Dallas TX - Hourly
Creation of api connection with UPS for check address and to create page for tracking - Fixed
Full Time Paranormal Investigator seeking weekly Video Production for YouTube. - Fixed

Similar Projects

Database design

Need a simple Database in MS Excel format. Need to store students information in one centralized database - from basic student records to testing information. and attendance. I need a form that can be utilized to make the information fillable.

Datamining From Specific Public Website

Need to have a Scarper created to pull information from BBB website. Will be given list of companies and their city/state. Just need the Contact Information associated with each company.

Cryptocurrency

Anyone who can get my money back from scammers Btc-global and mining poolhub

Program developer for a research work

Hello,
The job I have to do is to find an efficient way to extract phone numbers with a computer program that would send a request repeatedly.


First, I have to have all the possible phone number combinations in my city.

The...read more