Kapalı

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

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.)

Beceriler: Veri Girişi, Veri İşleme, Excel, Yazılım Mimarisi, Visual Basic

Daha fazlasını gör: how to copy data from one excel sheet to another using vlookup, how to get data from another sheet in excel using vlookup, vlookup to find matches in two columns, vlookup column index number cell reference, excel pull data from another sheet based on name, vlookup column index number from another sheet, how to copy data from one excel sheet to another using formula, how to extract data from excel, excel macro sort data existing sheets, excel consolidate data spread sheet, excel macro post data url sheet, excel macro moving data cell cell, excel macro internet data, excel macro oracle data entry, excel macro refresh data

İşveren Hakkında:
( 0 değerlendirme ) United States

Proje NO: #15854148

Bu iş için 46 freelancer ortalamada $25 teklif veriyor

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(563 Değerlendirme)
8.2
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(666 Değerlendirme)
7.7
schoudhary1553

Greeting, I have understood your Vlookup/ Match excel macro to sort data in spread [login to view URL] and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(245 Değerlendirme)
7.4
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(239 Değerlendirme)
6.9
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(153 Değerlendirme)
6.4
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(156 Değerlendirme)
6.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(37 Değerlendirme)
5.7
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(33 Değerlendirme)
5.8
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(41 Değerlendirme)
5.2
SShtv

Your task is clear to me and I am ready to do it for a total amount of 15USD Relevant Skills and Experience I have a lot of practical experience in Excel, including programming in VBA. [login to view URL] Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(48 Değerlendirme)
5.3
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

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(52 Değerlendirme)
5.2
nwss1986

Hi, The VLookup will do good, but we can also go with vba script, if the need be. Either way,I can start the work right now and will deliver in a couple of [login to view URL] me please.Thanks.

in %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(48 Değerlendirme)
4.8
in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
4.2
JackieXu

. Relevant Skills and Experience . Proposed Milestones $15 USD - .

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(19 Değerlendirme)
4.3
VinayOnTask

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(11 Değerlendirme)
4.2
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
3.4
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
3.9
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
3.8
NeetuSinghal

Excel work Relevant Skills and Experience i have 9 yrs of [login to view URL] handling excel Proposed Milestones $30 USD - output

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
3.6
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(14 Değerlendirme)
3.1