Create a macro that compares similar columns between two excel spreadsheet to create a third sheet.

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

I need an excel spreadsheet macro created for me to use on an ongoing basis. I will load unique data (in same format each time) each time I run this in the future and then run the macro. The macro button should be somewhere on Sheet 3 (named "Results").

The excel spreadsheet has 2 sheets (tabs of info). One of the columns in each of the tabs contains similar information (a stock ticker symbol which is between 1 and 5 letters). The first sheet has many duplicate rows of the same symbol in column N. The second sheet has only one row entry per symbol, and the symbol is found in column B on the second sheet. Both sheets have column headers in first row.

The macro should compare the symbol columns (again, column N in SHEET 1, and column B in SHEET 2) in each of two excel sheets within this file to make sure that the symbol exists on BOTH sheets. Then, if it is found on both sheets, ENTER THE ENTIRE ROW FROM THE 2ND SHEET ONTO A 3rd SHEET. So the 3rd sheet should look like the 2nd sheet (with same column headers as 2nd sheet), but with a reduced number of rows, (which have been eliminated because the symbol was not found on both sheets 1 and 2).

I may have other jobs similar in nature to this. I need this built within the next hour or so! Thanks.

Excel Excel Macros iMacros Excel VBA

Project ID: #20452654

About the project

14 proposals Remote project Active 4 years ago

Awarded to:

AnowarRatul

$ 15 ONLY!!! In just 1 Hour!! [EXCEL VBA MACRO EXPERT] Sir, please CONTACT with me, I can SEND you a DRAFT project file to ensure my EXPERTISE. If you are 100% satisfied first, then please award me the project. You c More

$15 USD in 1 day
(33 Reviews)
4.0

14 freelancers are bidding on average $24 for this job

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD in 1 day
(309 Reviews)
7.3
selopezr

Hello there! My name is Shamy López from Bolivia. I have several years of experience programming excel macros, and I'd be glad to serve you comparing and sheets 1 and 2 and composing sheet 3. Looking forwards to an opo More

$30 USD in 1 day
(26 Reviews)
4.6
nurnga1218

Hi, I've downloaded your spreadsheet and I think I can do it in approximately 20-40 minutes. But for make sure I'm doing correctly I need some discussion with you. So, I'm waiting for your chat. Thanks.

$25 USD in 1 day
(37 Reviews)
4.4
sunshine7677

Dear Client, I can do this. I have 5+ Years of Experience in Data Entry, Web Scrapping, Web Research and MS Office. I will be there during your working hours to provide support whenever you need. Let’s have a quick ch More

$30 USD in 1 day
(21 Reviews)
4.1
indrapandu

Hi, I can do it within one hour. Let's have a chat. I'll show you what I have done with your file.

$18 USD in 7 days
(18 Reviews)
3.9
ielucerotrad1

I can do it in an hour! I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlo More

$15 USD in 1 day
(15 Reviews)
4.0
bluesea1990

Hello. VBA expert. I'm very interesting in your project. I can develop your project perfectly. hope to discuss about your project detaily. thanks.

$30 USD in 1 day
(12 Reviews)
3.7
umairabdillah12

Hi There, I can help you to create a macro for your data, i have many experience using excel over 10 years. hope can help you. thanks. regards,

$15 USD in 1 day
(9 Reviews)
3.7
IgeS

I can design a macro that will transfer all data from main sheet to a validated data sheet if a certain unique id is found on the look up sheet to you within three hours. Relevant Skills and Experience Excel VBA

$25 USD in 1 day
(2 Reviews)
3.6
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be completed within a day. I've previously completed two projects that were both Macr More

$30 USD in 1 day
(4 Reviews)
2.6
Josephhekal

Dear, I’m a Data Scientist and Excel Expert. Have a wide range of technical competencies including: statistics, databases also collect, analyze, and interpret large data sets. I have extensive knowledge and expertise More

$12 USD in 1 day
(6 Reviews)
2.7
piyushshah901

Hi, I can't bid lower than USD 5. Matching columns in sheet 1 and 2 and creating a third sheet is a rather simple task which anyone can do if they know VBA. I'll do this project for free, in return I only ask that you More

$10 USD in 1 day
(0 Reviews)
0.0