Suoritettu

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.

Taidot: tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Wilmslow, United Kingdom

Projektin tunnus: #19783315

Myönnetty käyttäjälle:

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 Lisää

£100 GBP 3 päivässä
(120 Arvostelua)
6.9

23 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

£180 GBP 2 päivässä
(344 arvostelua)
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 Lisää

£100 GBP 3 päivässä
(233 arvostelua)
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 Lisää

£100 GBP 3 päivässä
(259 arvostelua)
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 Lisää

£120 GBP 3 päivässä
(213 arvostelua)
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 Lisää

£135 GBP 7 päivässä
(128 arvostelua)
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] Lisää

£150 GBP 2 päivässä
(98 arvostelua)
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 Lisää

£250 GBP 7 päivässä
(36 arvostelua)
5.9
afenache

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

£170 GBP 3 päivässä
(19 arvostelua)
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 7 päivässä
(30 arvostelua)
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 Lisää

£80 GBP 7 päivässä
(36 arvostelua)
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 1 päivässä
(20 arvostelua)
5.5
FreelancerTechX

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

£150 GBP 3 päivässä
(8 arvostelua)
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 Lisää

£35 GBP 1 päivässä
(20 arvostelua)
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 5 päivässä
(3 arvostelua)
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 Lisää

£80 GBP 5 päivässä
(5 arvostelua)
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 Lisää

£115 GBP 5 päivässä
(5 arvostelua)
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 Lisää

£250 GBP 1 päivässä
(6 arvostelua)
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 3 päivässä
(0 arvostelua)
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 Lisää

£222 GBP 3 päivässä
(0 arvostelua)
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 2 päivässä
(0 arvostelua)
0.0