Đã hoàn thành

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.

Kĩ năng: Xử lí dữ liệu, Excel, Kiến trúc phần mềm, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Wilmslow, United Kingdom

ID dự án: #19783315

Được trao cho:


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 Thêm

£100 GBP trong 3 ngày
(120 Đánh Giá)

23 freelancer đang chào giá trung bình £138 cho công việc này


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 Thêm

£180 GBP trong 2 ngày
(344 Nhận xét)

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 Thêm

£100 GBP trong 3 ngày
(233 Nhận xét)

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 Thêm

£100 GBP trong 3 ngày
(259 Nhận xét)

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 Thêm

£120 GBP trong 3 ngày
(213 Nhận xét)

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 Thêm

£135 GBP trong 7 ngày
(128 Nhận xét)

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] Thêm

£150 GBP trong 2 ngày
(98 Nhận xét)

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 Thêm

£250 GBP trong 7 ngày
(36 Nhận xét)

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

£170 GBP trong 3 ngày
(19 Nhận xét)

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 trong 7 ngày
(30 Nhận xét)

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 Thêm

£80 GBP trong 7 ngày
(36 Nhận xét)

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

£111 GBP trong 1 ngày
(20 Nhận xét)

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

£150 GBP trong 3 ngày
(8 Nhận xét)

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 Thêm

£35 GBP trong 1 ngày
(20 Nhận xét)

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 trong 5 ngày
(3 Nhận xét)

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 Thêm

£80 GBP trong 5 ngày
(5 Nhận xét)

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 Thêm

£115 GBP trong 5 ngày
(5 Nhận xét)

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 Thêm

£250 GBP trong 1 ngày
(6 Nhận xét)

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 trong 3 ngày
(0 Nhận xét)

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 Thêm

£222 GBP trong 3 ngày
(0 Nhận xét)

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 trong 2 ngày
(0 Nhận xét)