Find Jobs
Hire Freelancers

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

$10-30 USD

Finalizat
Data postării: peste 4 ani în urmă

$10-30 USD

Plata la predare
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.
ID-ul proiectului: 20452654

Despre proiect

14 propuneri
Proiect la distanță
Activ: 5 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
$ 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 în 1 zi
4,9 (33 recenzii)
4,0
4,0
14 freelanceri plasează o ofertă medie de $24 USD pentru proiect
Avatarul utilizatorului
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 în 1 zi
4,9 (309 recenzii)
7,3
7,3
Avatarul utilizatorului
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 în 1 zi
5,0 (26 recenzii)
4,6
4,6
Avatarul utilizatorului
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 în 1 zi
4,9 (37 recenzii)
4,4
4,4
Avatarul utilizatorului
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 în 1 zi
5,0 (21 recenzii)
4,1
4,1
Avatarul utilizatorului
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 în 7 zile
5,0 (18 recenzii)
3,9
3,9
Avatarul utilizatorului
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 în 1 zi
5,0 (15 recenzii)
4,0
4,0
Avatarul utilizatorului
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 în 1 zi
4,7 (12 recenzii)
3,7
3,7
Avatarul utilizatorului
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 în 1 zi
4,8 (9 recenzii)
3,7
3,7
Avatarul utilizatorului
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 în 1 zi
5,0 (2 recenzii)
3,6
3,6
Avatarul utilizatorului
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 în 1 zi
5,0 (4 recenzii)
2,6
2,6
Avatarul utilizatorului
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 în 1 zi
5,0 (6 recenzii)
2,7
2,7
Avatarul utilizatorului
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 în 1 zi
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul UNITED STATES
Dallas, United States
5,0
55
Metoda de plată a fost confirmată
Membru din aug. 28, 2008

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.