Find Jobs
Hire Freelancers

Solve Duplicating problem (VBA MACRO)

$10-30 USD

Imekamilika
Imechapishwa over 5 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates. State your approach to this task and I will hire you.
Kitambulisho cha mradi: 17539416

Kuhusu mradi

13 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 reputation points. I would like to offer my services for this project. I can try fixing the duplication issue on your worksheet. Actually waiting as you described is not a permanent solution. However, we can wait until a specific element is loaded. However, I would really need to have a look at your code and the website to see what exactly is getting duplicated and why. I assure the best in class services and fairest prices. Do consider me once, won't dissapoint you. Would wait for a positive and prompt response from your side :) Regards Sourabh
$25 USD ndani ya siku 1
5.0 (122 hakiki)
5.7
5.7
13 wafanyakazi huru wana zabuni kwa wastani $33 USD kwa kazi hii
Picha ya Mtumiaji
Hello, I can help with you in your project Solve Duplicating problem (VBA MACRO) I have more than 5 years of experience in Data Processing, Excel, PHP, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 380+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$50 USD ndani ya siku 2
4.9 (368 hakiki)
8.0
8.0
Picha ya Mtumiaji
I have excellent command on MS Excel and can solve the duplicating issue. Approach can be decided only after looking at the macro, so please share the file
$30 USD ndani ya siku 1
4.9 (104 hakiki)
6.1
6.1
Picha ya Mtumiaji
Dear Client, Before Awarding to Anyone give me a chance & kindly discuss your project in detail with me. I have read your requirement carefully and got total understanding of the project .No fake commitment,100% quality work. I have more than 8 years of experience in IT Services. I am always available on Email, WhatsApp and Skype. Please have a voice or video chat if necessary. I will be available more than 40 hours per week and able to start your project immediately after finalization. Thank you for taking the time to read my application. I look forward to talking with you. Regards Nikhil Singh
$15 USD ndani ya siku 1
4.7 (46 hakiki)
5.1
5.1
Picha ya Mtumiaji
am not a random bidder... I have 16 years of expertise with various project exposure.. Please visit my profile for more details.. thank you..
$100 USD ndani ya siku 1
4.9 (29 hakiki)
5.1
5.1
Picha ya Mtumiaji
Hello I have build numerous web scraping apps using VBA and I believe I can help you. I will have to examine your code before I can a give a better description to what my approach will be. Don't hesitate to contact me with any question you might have. Thanks for reading. Best regards, Michael.
$30 USD ndani ya siku 1
5.0 (34 hakiki)
4.3
4.3
Picha ya Mtumiaji
Hello I’d be able to help with your issue. My approach is dependant on seeing the macro work myself, however I would probably take one of two approaches: 1) use a remove duplicates function on the data 2) bespoke formula to work through data straight after its downloaded I have over 10 years experience with excel/vba for a global financial services firm where I automated many processes to create efficiencies and improve profitability. I’m sure I have the relevant experience to solve your issue. I hope to hear back from you soon. Kind regards Steve
$30 USD ndani ya siku 1
5.0 (8 hakiki)
3.9
3.9
Picha ya Mtumiaji
Do you use SeoTool to do a scrape or your own build tool. Send me your file I will take a look. Thank anyway
$25 USD ndani ya siku 1
5.0 (3 hakiki)
2.3
2.3
Picha ya Mtumiaji
Hello, I have 16 years of Experience in Excel sheet and I can easily fix your problem in a few hours. I look forward to hearing from you. Thanks Sounak
$20 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I am : - Big picture thinker, talented and driven to impact the bottom line profitability while ensuring staff compliance to business policies & procedures. - Advanced commercial business consultant & developer, skilled provider of on-job training, guidance and motivation that result in retention of top performance professionals. - Advanced communicator & cultivator of key relationships with all levels of personnel, clients, business as well as executive managers
$25 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hi there, I have been working with Excel for over a decade. I specialise in linking Excel with other applications. I am new to Freelancer but have been active on Furums since 2008. I would first see if I can fix the issue by looking at the readystate of the ie window, then I could look at excluding items by using a collection object in VBA which will not allow duplicates to be added. Failing this the duplicates could be removed after the data has been scraped or I may completely re-write the Macro that collects the data. Hope this makes sense Regards George
$20 USD ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hello, nice to meet you. I am an expert in programming with a little knowledge in algorithms. I carefully read your description and I am very interested in your project. I have two solutions about your problems: - The first one is to update the VBA code to remove duplicates. If there is no suitable functions to remove duplicates, I can make it possible to check duplicates by using some algorithm tricks (more details can be shared in chat). - Second one is to make an extra program to sanitizing the result. This is quite easier that the first one but I am not sure if you can accept it. Let's talk about the project in more details. Thank you for your attention. I am waiting for your reply.
$25 USD ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya KENYA
Nairobi, Kenya
5.0
25
Njia ya malipo imethibitishwa
Mwanachama tangu Sep 22, 2016

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.