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 May 20, 2018
Book Myotel
from Bergamo, Italy

Skills & Expertise Required

Data Mining Excel VBA Microsoft Excel Visual Basic VBA

Candidate shortlisted and hiredHiring open till - Sep 17, 2020

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

Implementation of a Wide Area Multi-site Network - Fixed
Dialogflow and API support - Hourly
Voice over for video courses - Fixed
Free Hand Sketch required for Interior design for event venue - Fixed
Seeking Graphic Designer to create x5 collages - Fixed
ColdFusion scheduled tasks not executing correctly - Hourly
Deveoper needed for creating an Robotic Process Automation on Uipath - Fixed
Cloud/Ops Platform Engineer II - Top Secret Clearance Required - Be You - Hourly
architectural drawing using SketchUp - Hourly
Counter espionage, assessment, digital security .Home office network.Counter RMON - Hourly
A wedding ceremony (no reception due to COVID) Live stream and/or video needed - Hourly

Similar Projects

Mechanical/Electrical Engineer is needed to compare both benchmarking companies in excel format.

Looking for an Engineer who understands well power and water sector and knows how to create a comparison table using excel to compare the services that both benchmarking companies offering.

The purpose of this project is to provide manageme...read more

Need someone proficient with excel to help me clean up a database

I have a database contained within one excel file but spread across multiple sheets. They need to be combined into one spreadsheet.

Urgent Data Entry

I have an urgent assignment for a data entry project.

I have a list with company name, first_name and last name with 134 records.

First, I require that you find the title and email for listed contact.

Secondly, find websit...read more

SEO data scrape for keyword difficulty

We need to scrape thousands of keywords for their allintitle search engine attribute (volume).

The simple search engine command is, allintitle:keyword.

We need an individual who has access to proxies and a tool similar to Scrape...read more

Google Sheets guru

I have a number of syndicated research downloads with column descriptors of the audience and about 1000 rows describing their behaviors, attitudes, media habits etc. Im looking for someone that could help me simplify it so that anyone could extract...read more