Find Jobs
Hire Freelancers

Excel - VBA Vlook up

$10-30 USD

Terminado
Publicado hace más de 5 años

$10-30 USD

Pagado a la entrega
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
ID del proyecto: 17758412

Información sobre el proyecto

27 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, can you please send me your excel file? I'll make a concept for you then I'll show you.
$30 USD en 2 días
5,0 (41 comentarios)
4,5
4,5
27 freelancers están ofertando un promedio de $36 USD por este trabajo
Avatar del usuario
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 en 1 día
4,9 (228 comentarios)
7,4
7,4
Avatar del usuario
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 en 1 día
4,9 (432 comentarios)
7,5
7,5
Avatar del usuario
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 en 1 día
4,9 (330 comentarios)
6,8
6,8
Avatar del usuario
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 en 3 días
4,9 (175 comentarios)
6,5
6,5
Avatar del usuario
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 en 1 día
5,0 (83 comentarios)
5,8
5,8
Avatar del usuario
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 en 1 día
4,8 (83 comentarios)
5,6
5,6
Avatar del usuario
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 en 2 días
4,8 (13 comentarios)
5,2
5,2
Avatar del usuario
I can surely help you to make all 3 steps you are looking form
$110 USD en 2 días
5,0 (15 comentarios)
4,7
4,7
Avatar del usuario
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 en 1 día
5,0 (21 comentarios)
4,4
4,4
Avatar del usuario
I am expert in such projects. Can do it right away with 100% satisfaction.
$100 USD en 1 día
5,0 (18 comentarios)
4,0
4,0
Avatar del usuario
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 en 2 días
5,0 (3 comentarios)
2,9
2,9
Avatar del usuario
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 en 2 días
2,3 (6 comentarios)
4,1
4,1
Avatar del usuario
Have 8years of experience in vbA
$25 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Could you please provide the spreadsheet spreadsheet I can look at the columns to be retrieved? Cheers, Ranjana
$40 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
4,0 (1 comentario)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Edmonton, Canada
4,9
10
Forma de pago verificada
Miembro desde may 14, 2008

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.