Find Jobs
Hire Freelancers

Excel - VBA Vlook up

$10-30 USD

Færdiggjort
Slået op over 5 år siden

$10-30 USD

Betales ved levering
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
Projekt-ID: 17758412

Om projektet

27 forslag
Projekt på afstand
Aktiv 6 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug Avatar.
Hi, can you please send me your excel file? I'll make a concept for you then I'll show you.
$30 USD på 2 dage
5,0 (41 anmeldelser)
4,5
4,5
27 freelancere byder i gennemsnit $36 USD på dette job
Brug 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 på 1 dag
4,9 (228 anmeldelser)
7,4
7,4
Brug 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 på 1 dag
4,9 (432 anmeldelser)
7,5
7,5
Brug 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 på 1 dag
4,9 (330 anmeldelser)
6,8
6,8
Brug 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 på 3 dage
4,9 (175 anmeldelser)
6,5
6,5
Brug 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 på 1 dag
5,0 (83 anmeldelser)
5,8
5,8
Brug 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 på 1 dag
4,8 (83 anmeldelser)
5,6
5,6
Brug 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 på 2 dage
4,8 (13 anmeldelser)
5,2
5,2
Brug Avatar.
I can surely help you to make all 3 steps you are looking form
$110 USD på 2 dage
5,0 (15 anmeldelser)
4,7
4,7
Brug 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 på 1 dag
5,0 (21 anmeldelser)
4,4
4,4
Brug Avatar.
I am expert in such projects. Can do it right away with 100% satisfaction.
$100 USD på 1 dag
5,0 (18 anmeldelser)
4,0
4,0
Brug 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 på 2 dage
5,0 (3 anmeldelser)
2,9
2,9
Brug 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 på 2 dage
2,3 (6 anmeldelser)
4,1
4,1
Brug Avatar.
Have 8years of experience in vbA
$25 USD på 2 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Could you please provide the spreadsheet spreadsheet I can look at the columns to be retrieved? Cheers, Ranjana
$40 USD på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug 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 på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug 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 på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug 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 på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug 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 på 3 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug 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 på 1 dag
4,0 (1 bedømmelse)
0,0
0,0

Om klienten

Flag for CANADA
Edmonton, Canada
4,9
10
Betalingsmetode verificeret
Medlem siden maj 14, 2008

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.