Convert Excel VBA spreadheet

Finalizat Postat la acum 4 ani S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

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.

Procesare date Excel Arhitectură software Visual Basic Visual Basic pentru aplicaţii

ID Proiect: #19783315

Detalii despre proiect

20 propuneri Proiect la distanță Activ acum 4 ani

Acordat lui:

kolosibalint

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 a Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% GBP în 3 zile
(134 Recenzii)
7.0

20 freelanceri plasează o ofertă medie de 139£ pentru proiect

schoudhary1553

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. Pl Mai multe

£180 GBP în 2 zile
(430 recenzii)
8.2
liangjongai

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 Regard Mai multe

£100 GBP în 3 zile
(250 recenzii)
7.8
paris2785

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 Mai multe

£120 GBP în 3 zile
(293 recenzii)
7.7
deepbluetech

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 unde Mai multe

£100 GBP în 3 zile
(259 recenzii)
7.4
khanicha

You cant use the common iteration method, this will take much time of processing. use SQL statement method for faster processing.

£111 GBP în 1 zi
(42 recenzii)
6.5
zu02

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 Mai multe

£250 GBP în 7 zile
(38 recenzii)
5.9
FreelancerTechX

Dear Sir/Madam, I fully understand your requirements. Ready to start ***************************************************************

£150 GBP în 3 zile
(27 recenzii)
5.4
afenache

Hi, I can write a faster VBA script for your excel email finder tool. Best regards, Florin Enache

£170 GBP în 3 zile
(22 recenzii)
5.3
musthree

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 Mai multe

£250 GBP în 1 zi
(8 recenzii)
5.0
xinglong717

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 în 7 zile
(36 recenzii)
5.3
rIbrarahmed

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 myse Mai multe

£35 GBP în 1 zi
(27 recenzii)
4.9
malikasad079

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 Mai multe

£115 GBP în 5 zile
(10 recenzii)
3.9
kesavannil

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 în 5 zile
(3 recenzii)
3.8
vikramshibad

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 Mai multe

£222 GBP în 3 zile
(1 părere)
1.8
diepkha

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 în 3 zile
(1 părere)
1.1
rohansdhek

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 în 2 zile
(0 recenzii)
0.0