Completed

Excel - VBA Vlook up

I have a spread sheet with one tab that has a master list of phone numbers. It has to go and look at 3 other tabs to see if the exact match exhists. One of the tabs has multiple columns where it needs to check.

What im looking for is VBA to:

1)Create a new tab and name it something of my choice.

2)Copys columns from all tabs identified and places them into essentially 4 columns with appropriate headers

3)A new column that does the lookup (against the master column) and reports back if/what the match is and what column is resides in.

Im open to other suggestions but i need something quick and repeatable. I have nearly 100 excel sheets that need to be validated

Skills: Excel, Visual Basic, Visual Basic for Apps

See more: excel vba vlookup in another worksheet, vba code for vlookup between two sheets, excel vba vlookup table, excel vba vlookup in another workbook, excel vba vlookup array, vba vlookup range, msdn excel vba vlookup, excel vba vlookup named range, excel vba error, excel vba add installation, excel vba xml post, excel vba menu code, excel vba word style heading, excel vba access vba, simple excel vba, excel vba macro paste adjacent column, excel vba lock sheet user script, excel vba lookup script, excel vba lookup cut cell, excel vba conditional lookup

About the Employer:
( 9 reviews ) Edmonton, Canada

Project ID: #17758412

Awarded to:

nurnga1218

Hi, can you please send me your excel file? I'll make a concept for you then I'll show you.

$30 USD in 2 days
(39 Reviews)
4.5

30 freelancers are bidding on average $35 for this job

SBITServices

Hello Casey, I can write Excel macro for moving matched data into new tab as you required. I have 2.5 years experience in Excel VBA programming, advanced concepts like Pivot table, Vlookup, Charts, Data More

$30 USD in 1 day
(352 Reviews)
7.3
paris2785

Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to develop the VBA code to create a new tab and gather data that matches a key word of your c More

$30 USD in 1 day
(156 Reviews)
6.8
TonmoyRoy111

Dear client I can write the macro code for the requirements you mentioned. I ensure you will be happy after hiring me. Kindly contact me for further details. Roy

$30 USD in 1 day
(258 Reviews)
6.5
avinav606lx

Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. P More

$40 USD in 3 days
(170 Reviews)
6.5
supper5guy

Hello thee, as an expert in excel and VBA, i can help you automate your lookup and validation process. Please contact me and let us talk more about your project. Thanks

$28 USD in 1 day
(55 Reviews)
5.0
whitehorsetechn

Hello! This is white horse Technologies and I was glad to see that you're looking for help for project Excel - VBA Vlook up. I've delivered more than 40 projects in the last 1 years and this makes me very confiden More

$100 USD in 2 days
(13 Reviews)
5.2
$30 USD in 1 day
(49 Reviews)
5.3
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical More

$30 USD in 1 day
(65 Reviews)
5.2
aubrey03

I am an Excel specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$30 USD in 1 day
(34 Reviews)
5.0
serdaryalcin

Hi, The format of the all files are the same I assume. If so I can write a short macro that can do what you want. How many rows does this files have? If more than 100.000 then we must think about a search algorithm More

$30 USD in 1 day
(21 Reviews)
4.4
Developer000

I can surely help you to make all 3 steps you are looking form

$110 USD in 2 days
(12 Reviews)
4.5
Mfaisalshahzad00

I am expert in such projects. Can do it right away with 100% satisfaction.

$100 USD in 1 day
(18 Reviews)
3.9
krishnaagr89

Hi,I have read your requirements of Excel - VBA Vlook up and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You can re More

$24 USD in 2 days
(3 Reviews)
2.9
marloufin

Hi there, we can use find instead of a vlookup to more readble and easy to maintain. I've been in excel vba macro for 3 years and currently creating company tools for users reporting. Willing to help you with your proj More

$35 USD in 2 days
(5 Reviews)
4.0
Cobse

Hi. I can easily do this. You are sure you want formulas and not some VBA solution? I can do it both ways. Instead of Vlookup I'll probably use a combination of Index match. Kind regards Fredrik

$20 USD in 1 day
(1 Review)
1.0
fadhilahadam1809

My Proposal; Prepare a macro which can copy and paste the required data from all the sheets. And the run the data against the same macro/or a separate macro to run the lookup and finally displaying the result. H More

$27 USD in 1 day
(0 Reviews)
0.0
arsantra

I have done a lot VBA excel work in my organisation. can do it in less time. You can expect good and on time delivery

$25 USD in 1 day
(1 Review)
0.1
matemora0607

Hello! I can help you. If you can send me some of the sheets you need to validate, i can write a code for you, that will perform those actions. Let me know if you need anything else!

$20 USD in 3 days
(0 Reviews)
0.0
$30 USD in 1 day
(0 Reviews)
0.0
$25 USD in 3 days
(0 Reviews)
0.0