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
Laurent Gagnon
from Hanoi, Vietnam

Skills & Expertise Required

Data Mining Excel VBA Microsoft Excel Visual Basic VBA

Open for hiringApply before - Oct 22, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.80

Cost

Offer to work on this project closes in 90 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

CEC Accredited Electircian needed for Solar System Installation in Melbourne, Victoria - Hourly
setup Ubuntu VNC on VPS - Hourly
Amazon Retail Arbitrage VA - Hourly
Google Sheets Expert & Consultant Needed - Hourly
Full stack web developer needed for ongoing web projects - Fixed
Answering Service to include email and chat support agent in English. - Hourly
Mobile App Development - Fixed

Similar Projects

Excel to Oracle Database

We need to populate an Oracle Table based on Data generated with Microsoft Excel

Find Contact Person Behind Corporation Names - Real Estate Investors

I will give you an excel list of data which includes corporation names. I need you to use corporationwiki, bizapedia, google, linkedin, connectedinvestors, facebook, and any other ways to find out the names and contact person behind a corporation....read more

BI/ Google data studio expert - Amazon Sales/ PPC campaigns

Hi Up work community,

Im looking for a strong data analyst that can assist me with producing beautiful reports.
The data analyst will need to:

1. Develop dashboards and reporting presentation decks to clearly communicate bus...read more

Excel Ninja to translate Binary Bot Trading strategy

Hi,

We are looking for an excel ninja!

The project is to test bot trading strategy for binary options. The main principle is to bet if a certain data is a certain way or not. We will provide data from volatility. Each volatility is...read more

Excel Data Visualization - Survey results

I have an excel projectfrom survey dataI would like to turn into visual data.I have a total of 8 columns(with scores from 1-10 in each row), and I want to break it down like this:Column 8 - average total scoreThen for columns 1-7, I would like to sho...read more