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

$10-30 USD

Imekamilika

Imechapishwa

over 4 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa

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.

Kitambulisho cha mradi: 20452654

Kuhusu mradi

14 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@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 can see my profile to get overview of what my past employers think about me. I will be very much grateful if I get opportunity to work for you. Thanks, Anowar

$15 USD ndani ya siku 1

4.9

(33 hakiki)

4.0

14 wafanyakazi huru wana zabuni kwa wastani $24 USD kwa kazi hii

@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 ndani ya siku 1

4.9

(309 hakiki)

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 oportunity of working for you,

$30 USD ndani ya siku 1

5.0

(26 hakiki)

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 ndani ya siku 1

4.9

(37 hakiki)

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 chat to discuss this project. Looking forward to hear from you soon. Thanks & Regards, Ritika Keshri

$30 USD ndani ya siku 1

5.0

(21 hakiki)

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 ndani ya siku 7

5.0

(18 hakiki)

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, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).

$15 USD ndani ya siku 1

5.0

(15 hakiki)

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 ndani ya siku 1

4.7

(12 hakiki)

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 ndani ya siku 1

4.8

(9 hakiki)

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 ndani ya siku 1

5.0

(2 hakiki)

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 Macro related.

$30 USD ndani ya siku 1

5.0

(4 hakiki)

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 in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, drop-down boxes and charts. As a dedicated professional with solid experience in accurate and timely data entry, I am well positioned to exceed your expectations in this position. I could help you out perfectly as soon as humanly possible. I'm very interested in your offer and i would like to take the responsibility of getting this job done. Have time to start immediately. Please send me a reply if you would like to talk more. Best Regards,

$12 USD ndani ya siku 1

5.0

(6 hakiki)

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 give me more projects (paid) in the future if you like my work. I want to build my profile. Please message me if you're interested in the offer. It'll save you a couple bucks and earn a good freelancer who'd always be available on a short notice. Thanks :)

$10 USD ndani ya siku 1