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
Don Hickey
from Gorenjska, Slovenia

Skills & Expertise Required

Data Mining Excel VBA Microsoft Excel Visual Basic VBA

Candidate shortlisted and hiredHiring open till - Jul 11, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$47.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

BI Consultant - Hourly
create pinterest pin daily 5 pieces - Hourly
Facebook Ad Specialist - Hourly
Microsoft Dynamics 365 Development, Configuration, App Integration, and Reporting - Hourly
Google Analytics Consultant - Hourly
Expert WooCommerce Product Import Needed - Hourly
Developer Needed to Create Restaurant Wait List Application for Wordpress - Fixed
Need SEO For Website - Fixed
modify existing excel script - Fixed
Data Analyst and Reporting Expert - Hourly
Need Tech Assistant for Chrome malware issue - Hourly
Solutions Architect - Hourly

Similar Projects

Database of maintenance managers

Who we are =>
Alldevicecmms is a leading cloud-based maintenance management solution that simplifies the work of maintenance managers in production companies.

What we need =>
We need a database of contacts of MAINTENANCE MANAGERS who...read more

Collect info from Golf Course websites

I have a list of golf courses that I need to collect information from. This includes website URL, contact information, course information, and more.

I have been compiling this myself for a bit, so I can provide a sample spreadsheet of what...read more

Linkedin Scraping for Employees via Software

We need to create some databases based on employees with specific job positions and/or work at a specific company.

This needs to be done via software scraping. not manual hand scraping. i need quick turn arounds. what i will do is provide y...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