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 - Feb 2, 2022

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$34.76

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
Looking for a forex trader mentor (long term) - Fixed
Structural Engineer needed for Live Oak condo in Dallas TX - Hourly

Similar Projects

Create a revenue dashboard in Google Data Studio using first interaction model from GA

Hello

Im struggling to create a dashboard in GDS with the revenue from paid search but with model first interaction (last is by default).

I would be glad if you show me the solution :)

Zillow data scrape

I want to create a spreadsheet of all the agents/posters who posted a house for sale in San Diego ca, Corpus Christi tx, and Tallahassee FL in the pst 2 years. Looking for full name of poster/agent, phone number, address of agent (if applicable), pho...read more

Need a Crystal Reports Ninja to build custom reports using third-party software for our partners.

BACKGROUND: Daniels Communications, Inc. is a third-generation family owned company specializing in answering service and call center services. Our software, Amtelco, is very prominent in the answering service space. This software provides approxi...read more

Helping in convert Ruby code to Python

I have a code with ruby language and I need help in covert it to python, The code for bio-inspired algorithm for classification