Find Jobs
Hire Freelancers

Convert Excel VBA spreadheet

£20-250 GBP

Færdiggjort
Slået op næsten 5 år siden

£20-250 GBP

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

Om projektet

20 forslag
Projekt på afstand
Aktiv 5 å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, 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 på 3 dage
5,0 (134 anmeldelser)
7,0
7,0
20 freelancere byder i gennemsnit £139 GBP på dette job
Brug Avatar.
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 på 2 dage
4,9 (430 anmeldelser)
8,2
8,2
Brug Avatar.
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 på 3 dage
5,0 (250 anmeldelser)
7,8
7,8
Brug Avatar.
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 på 3 dage
4,9 (293 anmeldelser)
7,7
7,7
Brug Avatar.
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 på 3 dage
5,0 (259 anmeldelser)
7,4
7,4
Brug Avatar.
You cant use the common iteration method, this will take much time of processing. use SQL statement method for faster processing.
£111 GBP på 1 dag
4,5 (42 anmeldelser)
6,5
6,5
Brug Avatar.
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 på 7 dage
4,7 (38 anmeldelser)
5,9
5,9
Brug Avatar.
Dear Sir/Madam, I fully understand your requirements. Ready to start ***************************************************************
£150 GBP på 3 dage
5,0 (27 anmeldelser)
5,4
5,4
Brug Avatar.
Hi, I can write a faster VBA script for your excel email finder tool. Best regards, Florin Enache
£170 GBP på 3 dage
5,0 (22 anmeldelser)
5,3
5,3
Brug Avatar.
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 på 1 dag
5,0 (8 anmeldelser)
5,0
5,0
Brug Avatar.
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 på 7 dage
4,9 (36 anmeldelser)
5,3
5,3
Brug Avatar.
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 på 1 dag
4,8 (27 anmeldelser)
4,9
4,9
Brug Avatar.
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 på 5 dage
5,0 (10 anmeldelser)
3,9
3,9
Brug Avatar.
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 på 5 dage
4,8 (3 anmeldelser)
3,8
3,8
Brug Avatar.
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 på 3 dage
5,0 (1 bedømmelse)
1,8
1,8
Brug Avatar.
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 på 3 dage
5,0 (1 bedømmelse)
1,1
1,1
Brug Avatar.
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 på 2 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED KINGDOM
WILMSLOW, United Kingdom
5,0
1
Betalingsmetode verificeret
Medlem siden maj 26, 2019

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.