Find Jobs
Hire Freelancers

Excel - VBA Vlook up

$10-30 USD

Completed
Posted over 5 years ago

$10-30 USD

Paid on delivery
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
Project ID: 17758412

About the project

27 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
5.0 (41 reviews)
4.5
4.5
27 freelancers are bidding on average $36 USD for this job
User Avatar
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 choice. It's a common task for me. I've delivered more than 240 projects in the last 5 years and this makes me very confident with your task. I can deliver the project within 1 day for $30. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Sincerely, Paris Pallas
$30 USD in 1 day
4.9 (228 reviews)
7.4
7.4
User Avatar
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 analyser etc.. I can complete task within time with 100% accuracy. With Regards, Sai
$30 USD in 1 day
4.9 (432 reviews)
7.5
7.5
User Avatar
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
4.9 (330 reviews)
6.8
6.8
User Avatar
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. Ping me to discuss project , timeline and budget. Thanks A
$40 USD in 3 days
4.9 (175 reviews)
6.5
6.5
User Avatar
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
5.0 (83 reviews)
5.8
5.8
User Avatar
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 Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$30 USD in 1 day
4.8 (83 reviews)
5.6
5.6
User Avatar
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 confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.
$100 USD in 2 days
4.8 (13 reviews)
5.2
5.2
User Avatar
I can surely help you to make all 3 steps you are looking form
$110 USD in 2 days
5.0 (15 reviews)
4.7
4.7
User Avatar
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 also. Please provide a sample for further talk. REgards
$30 USD in 1 day
5.0 (21 reviews)
4.4
4.4
User Avatar
I am expert in such projects. Can do it right away with 100% satisfaction.
$100 USD in 1 day
5.0 (18 reviews)
4.0
4.0
User Avatar
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 reach me at any time on online . I have also a few clarifying questions on the project.I’m an Expert, Honest, Sincere, Quick learner and Responsible worker as I’m taking my work like my Responsibility. kind regards.
$24 USD in 2 days
5.0 (3 reviews)
2.9
2.9
User Avatar
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 project, just let me know and we can discuss it further. Thanks, Marlou
$35 USD in 2 days
2.3 (6 reviews)
4.1
4.1
User Avatar
Have 8years of experience in vbA
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Could you please provide the spreadsheet spreadsheet I can look at the columns to be retrieved? Cheers, Ranjana
$40 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a VBA expert with 6+ years of expertise in Excel, Work and Outlook VBA macros and integration across applications. I am very much clear about the requirement and I consider myself apt for this requirement. I will deliver an excellent quality project at the cheapest price. Let me know if you want to discuss in detail. Regards, Mohak
$22 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert in Microsoft Excel Spreadsheet formulas and Visual Basic (VBA) programming for Excel files. I am willing to do the first project at minimum price in order to demonstrate skills, earn good feedback and recommendations for future work. Samples of my work in Excel and Excel VBA can be viewed on my portfolio.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I see you were looking for something like a excel spreadsheet. I think you won't need a VBA program to do this kind of work. I suggest you hire someone who knows more about match and index function. It will give you the exact thing you were trying to do without hassle of doing a vlookup function which is not applicable if you have names/product that have the same name in your master column. If you have a minute you could inbox me and we could talk more about this. Thanks, JM.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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
4.0 (1 review)
0.0
0.0

About the client

Flag of CANADA
Edmonton, Canada
4.9
10
Payment method verified
Member since May 14, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.