Completed

Convert Excel VBA spreadheet

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.

Skills: Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps

See more: excel vba export sheet to new workbook, excel vba import worksheet from another workbook, vba copy sheet from another workbook to current workbook, excel macro import data from another workbook, convert excel macros to google sheets, excel vba import data from another excel file, excel vba copy worksheet to another workbook, excel vba copy worksheet to existing worksheet, convert excel vba application, convert excel vba sql, convert excel vba dll, convert excel vba macro standalone application, convert excel vba access, convert excel vba, convert excel vba visual basic, convert excel vba open office calc, convert excel vba openoffice, convert excel vba project access, convert excel vba openoffice basic, convert excel vba open office basic

About the Employer:
( 0 reviews ) Wilmslow, United Kingdom

Project ID: #19783315

Awarded to:

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 More

£100 GBP in 3 days
(120 Reviews)
6.9

23 freelancers are bidding on average £138 for this job

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 More

£180 GBP in 2 days
(344 Reviews)
7.9
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 More

£100 GBP in 3 days
(233 Reviews)
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 More

£100 GBP in 3 days
(259 Reviews)
7.4
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 More

£120 GBP in 3 days
(213 Reviews)
7.3
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... https More

£135 GBP in 7 days
(128 Reviews)
6.9
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] More

£150 GBP in 2 days
(98 Reviews)
5.7
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 More

£250 GBP in 7 days
(36 Reviews)
5.9
afenache

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

£170 GBP in 3 days
(19 Reviews)
5.2
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 in 7 days
(30 Reviews)
5.1
dungforever

Hi I am an experienced and skillful data entry and web scrapping expert. I have rich experiences with excel, excel vba and web scrapping. I can finish your data entry project in time I promise high quality. Hope your k More

£80 GBP in 7 days
(36 Reviews)
5.3
khanicha

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

£111 GBP in 1 day
(20 Reviews)
5.5
FreelancerTechX

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

£150 GBP in 3 days
(8 Reviews)
4.2
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 More

£35 GBP in 1 day
(20 Reviews)
4.2
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 in 5 days
(3 Reviews)
3.8
iMonte555

Hello, How are you? I've read carefully your job description. I have more than 3 years experience in vba. Your satisfaction with the project is my top priority! If you give me a chance to work with you, then I wil More

£80 GBP in 5 days
(5 Reviews)
3.4
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 More

£115 GBP in 5 days
(5 Reviews)
3.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 More

£250 GBP in 1 day
(6 Reviews)
3.1
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 in 3 days
(0 Reviews)
0.0
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 More

£222 GBP in 3 days
(0 Reviews)
0.0
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 in 2 days
(0 Reviews)
0.0