Find Jobs
Hire Freelancers

Convert Excel VBA spreadheet

£20-250 GBP

Terminado
Publicado hace casi 5 años

£20-250 GBP

Pagado a la entrega
We have an Excel spreadsheet which with some basic VBA code we have written to check customer emails against a physical address key so that we can get all emails associated with an address to enable us to better exclude customer or target customers from email campaigns, where customers or households have used multiple emails and/or multiple physical addresses. We have around 250k unique combinations of emails and address key. However, to run the code, for say just a few thousand email addresses and address keys, against this data set takes a few hours. We need this coding in something that will do this much quicker. I have uploaded the file with sample data so you can see what we want.
ID del proyecto: 19783315

Información sobre el proyecto

20 propuestas
Proyecto remoto
Activo hace 5 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, I reviewed your script and I found quite a few reasons why it's slow and how it can be faster: -variables are not defined (undefined variable take much more memory than declared ones) -sheets are not defined as object but they are always used with their full names -With clauses could be used in a more effective way -selecting cells is usually unnecessary and takes time I'm happy to rewrite your script to make it faster. Regards, Balint
£100 GBP en 3 días
5,0 (134 comentarios)
7,0
7,0
20 freelancers están ofertando un promedio de £139 GBP por este trabajo
Avatar del usuario
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
£180 GBP en 2 días
4,9 (430 comentarios)
8,2
8,2
Avatar del usuario
Hello, sir! I am Wu. I am full time developer. I have mastered Excel VBA and C#, Java. I am very interesting your project and can give good result. Please discuss with me about your project. Thanks. Best Regards.
£100 GBP en 3 días
5,0 (250 comentarios)
7,8
7,8
Avatar del usuario
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will help in retrieving unique email addresses. I will charge you 120 pounds and can deliver within three days (a single milestone to release once you're satisfied with the final result). I'm among the most experienced and skilled Excel, and VBA developers on this platform. I am in the top 3% of the freelancers having completed over 300 projects successfully in six years, and I feel confident in achieving your task as well. You're welcome to visit my page (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
£120 GBP en 3 días
4,9 (293 comentarios)
7,7
7,7
Avatar del usuario
Hi, Had a look at the Excel VBA code and I can definitely make the code run faster while processing 250k lines of data. I suppose Sheet2 with email data upto Row 474 pertains to the actual email data to be filled under column A of 'Output emails' sheet. Let me know and I can start working on the project right away. Thanks, Arul
£100 GBP en 3 días
5,0 (259 comentarios)
7,4
7,4
Avatar del usuario
You cant use the common iteration method, this will take much time of processing. use SQL statement method for faster processing.
£111 GBP en 1 día
4,5 (42 comentarios)
6,5
6,5
Avatar del usuario
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel /VBA. I can code that via Ms Access app based on your Email Iterative Finder sample data.xlsm. I'm Ms Access/VB/SQL/Excel programmer since 1997. Really all my projects here I've developed for Ms Access/VB/SQL/Excel projects. Please visit :https://www.freelancer.com/u/zu02?w=f Thank you for your consideration. Zura
£250 GBP en 7 días
4,7 (38 comentarios)
5,9
5,9
Avatar del usuario
Dear Sir/Madam, I fully understand your requirements. Ready to start ***************************************************************
£150 GBP en 3 días
5,0 (27 comentarios)
5,4
5,4
Avatar del usuario
Hi, I can write a faster VBA script for your excel email finder tool. Best regards, Florin Enache
£170 GBP en 3 días
5,0 (22 comentarios)
5,3
5,3
Avatar del usuario
Hi, I am an expert in Excel and VBA programming. Let me do it for you so the program finishes processing in a few minutes. I can finish today. Also let me show some similar projects if you want. This situation is a bit tricky and you should use special techniques to make the program very fast. Otherwise, it will not take only a few hours, instead it will take days to finish 250k records. Regards.
£250 GBP en 1 día
5,0 (8 comentarios)
5,0
5,0
Avatar del usuario
VBA , data structure , algorithm expert. I have many experiences. I can complete your project successfully. I'm software engineer and algorithm expert. I'm fullstack website developer and database manager. Thanks.
£250 GBP en 7 días
4,9 (36 comentarios)
5,3
5,3
Avatar del usuario
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
£35 GBP en 1 día
4,8 (27 comentarios)
4,9
4,9
Avatar del usuario
I am writing in response to your advertisement for a Visual Basic, Data Processing, Excel, Software Architecture, Visual Basic for Apps. After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I feel that I can add professionalism and accuracy to your current team of professionals. With extensive experience supporting all levels of a department and working directly with external vendors, I take direction well and can complete a heavy workload and complete projects under minimal supervision. If you feel there is a mutual interest, I would welcome the opportunity to meet with you to learn more about your company, the requirements of the position, and how my qualifications would be a good fit. Thank you in advance for your time and consideration. I look forward to Hiring from you soon.
£115 GBP en 5 días
5,0 (10 comentarios)
3,9
3,9
Avatar del usuario
Hi, I have good experience with VBA macros development. If project provided will be able to deliver on time with good code quality. Please feel free to mail me for further communication.
£122 GBP en 5 días
4,8 (3 comentarios)
3,8
3,8
Avatar del usuario
Please see if my understanding of your project is correct - - Households are identified by address key which represents physical address. - Customers (and target customers) are associated with physical addresses as well as email IDs. - Some households / customers may be associated with multiple email IDs or multiple physical addresses. - There is a need to determine such households / customers in order to minimize the sending of campaign material multiple times to the same people. - This matching and identification is currently being done in VBA. However, it takes an unreasonably / inconveniently long time. This project is to implement the logic in a way that does it much faster without losing any existing features. Approach I would take - - Use a low-cost relational database (ideally suited for such grouping). - Set up integration between your Excel workbook and the RDBMS, and a way to consume the output. Similar work I have done -- Dashboards and calculators for project management, financial calculations, software testing, etc My strengths -- - several years' experience with Excel VBA development and always excellent feedback from my clients. - easy to communicate with. - bottomline responsibility for delivering on-time and with high quality of work. - I am new to freelancer and eager to establish my credentials, hence the low quote. I will do everything possible to make your project successful
£222 GBP en 3 días
5,0 (1 comentario)
1,8
1,8
Avatar del usuario
I have a lot of experience in data processing, checking and fixing errors in excel and VBA excel. I can help you fix the VBA code to help the program run faster.
£55 GBP en 3 días
5,0 (1 comentario)
1,1
1,1
Avatar del usuario
Expert in excel and client servicing and will serve you at the minimum. having experience of more than 5 years and will take care of your business as i am in the same from last 4 years
£20 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
WILMSLOW, United Kingdom
5,0
1
Forma de pago verificada
Miembro desde may 26, 2019

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.