Vlookup/ Match excel macro to sort data in spread sheet.

Ukončen Zveřejněno před 6 lety K zaplacení v momentě doručení
Ukončen K zaplacení v momentě doručení

PROBLEM: I have a mass of data in an excel spreadsheet that I need to correlate with another Excel spreadsheet, and export the "overlap" between the two spreadsheets to a new spreadsheet.

THE DATA: The spread sheet has many columns but I only care about 4 columns. The other spreadsheet is not as large as the first and definitely manageable.

MY "SOLUTION": I want a VLookup or Match script that will search the data, correlate between the two spreadsheets and export the selected result to a new spread sheet. (You can suggest a different approach if my solution is not the best.)

Zadávání dat Zpracování dat Excel Softwarová architektura Visual Basic

Identifikační číslo projektu: #15854148

O projektu

43 nabídek Projekt na dálku Aktivní před 6 lety

43 Freelnceři na tento projekt zveřejňují nabídky v průměru $25

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En Další

$50 USD za 1 den
(846 Recenzí)
8.9
cgullapalli

HI, I am good at Excel and vba. I have reviewed the project details. My suggestion is to copy the data and use conditional formatting to check it quickly the duplicates with a helper column -Chandra Relevant Skills a Další

$30 USD za 0 dní
(1095 Recenzí)
8.3
P0L

Hey, I'm interested in your project. Please send me a message so that we can discuss more. Stay tuned, I'm still working on this proposal.

$20 USD za 1 den
(490 Recenzí)
8.0
avinav606lx

Hi there, This looks feasible and I can use array or SQL queries to make it fast and efficient. I am expert in Excel VBA with over 5+ years of experience. Ping me to discuss more about the project. Thanks Aman

$35 USD za 1 den
(179 Recenzí)
6.6
rengrish

Hi I have multiple suggestion based on vlookpup ,countif,match functions in cojunction. I can complete the job within 20 minutes. I need data files. I have 10+ years of experience in Excel Relevant Skills and Experien Další

$30 USD za 1 den
(181 Recenzí)
6.1
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects Relevant Skills and Experience E Další

$35 USD za 1 den
(78 Recenzí)
6.2
zu02

Hi, there I can code your current Excel using sql/ado coding within - that's a just proper way here in your task Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office 97 released Prop Další

$55 USD za 1 den
(42 Recenzí)
6.2
Anasra

Hi ! Let me help you i will check which formula will helpful for getting require results. Thank you ! Relevant Skills and Experience Have 5 years of excel exp Proposed Milestones $10 USD - excel work

$10 USD za 0 dní
(72 Recenzí)
5.8
afenache

Hi, I have over five years experience in using Excel at an advanced level (formulas, macros, automatic calculation sheets) as an Industrial Engineer at Michelin. I am always keen to improve my work quality and produc Další

$20 USD za 2 dní
(23 Recenzí)
5.7
nelumindralal

Hello, I went thru the des. This can be done within today Kindly check my past job work and vllokup or match will do this Today can start. Looking forward to hearing from you Thanks Regards Thushara Relevant Skills Další

$25 USD za 0 dní
(37 Recenzí)
5.1
haleem0786

I have good command over MS Excel especially povit table, charts, advance formulas etc, codes. do let me know more detail in PM. thanks

$30 USD za 1 den
(33 Recenzí)
4.4
VinayOnTask

A proposal has not yet been provided

$30 USD za 1 den
(11 Recenzí)
4.2
Nicecreator

Dear Customer . i understand your requirement and will Provide sample work within 1 hours. trust me and Hire me . Relevant Skills and Experience I have complited many data analytical work high quality and accuracy l Další

$12 USD za 0 dní
(12 Recenzí)
3.7
thuyduongrands

25 USD for 1 day working Relevant Skills and Experience I have over 10 years of experience and knowledge of accounting and good skill data entry, good at Office software and Xero, Myob, Quickbooks software all so Pro Další

$25 USD za 1 den
(7 Recenzí)
3.8
rajenranpara

Hello sir, I am a computer engineer. I am working with software development and debugging. I read the task details. Using VLookUp is definitely what you can go for but if you want to automate it, you can have a u Další

$30 USD za 3 dní
(13 Recenzí)
4.2
JohnnyZhu

A proposal has not yet been provided

$25 USD za 1 den
(4 Recenzí)
3.0
SoufianeAch

Create a Vlookup/match formula in excel Relevant Skills and Experience Hi! I have experience in excel. I've complete many automating task with excel for the company I was interning in. I am rigorous and conscientious; Další

$25 USD za 1 den
(6 Recenzí)
2.7
viswakarmaya

its a simple program of link up, sort and compare. Would complete the project in 6 hrs of starting the project

$15 USD za 0 dní
(3 Recenzí)
1.4
beban

The solution of the problem with VLookup, Match or with other appropriate excel formula can be done. Relevant Skills and Experience excel Proposed Milestones $25 USD - day

$25 USD za 1 den
(1 recenze)
0.0
vnjmthota

enough exp in this sub matter

$15 USD za 1 den
(0 Recenzí)
0.0