Refactor VBA code to reduce execution time

ID : 34358305 Greetings, We are interested to work on this project, please find my comments inline with yours in following link. 1. I have written a VBA code for a large data set. I would like you to refactor it in order to improve the execution time. => I had went through the "EIR" excel file and its code. I would like to discuss with you about this project so that I can estimate time and cost for the same. We are Microsoft Access and SQL server database developers, about the experience My senior colleague has over 21 years experience and I have a 7 year of experience in building Microsoft access databases for various industry types and purpose, we do have contracts with couple of companies for long-term support. We had initial development of database for these companies. And on a ongoing basis we are making changes and/or supporting for bugs, improvements etc. We worked on over 530 Microsoft Access projects till now. It is a great tool when scaling-up and excellent reporting features. We follow engineering methodologies, naming conventions. We do Documentation for ease of maintenance in long run. Regards Sonali

hello I can help with the project. Maybe will take few hours. It need to do all formula using array and calculation using VBA but not Excel formulas This will give fantastic speed ( less then second ) not for only about 40000 row, but 2-3 time more data too I have 15+ year experience of Excel, Excel VBA, Python and 100% feedback So, you can trust to me. Result will be excellent Best Regard

Hello, We have been working on excel, vba, macros, finance for more than 9 years. We have more than 8 years of experience doing data based projects. I believe this is something I can for sure :) You may check the projects I have already completed here: https://www.freelancer.com/projects/excel/Excel-VBA-Data-Entry-Analysis-32285292/reviews https://www.freelancer.com/projects/excel/Data-Analytics-Project-30073140/details https://www.freelancer.com/projects/data-mining/DATA-MINING-ANALYSIS-USING-NEURAL/reviews https://www.freelancer.com/projects/excel/Hire-Excel-Expert-15193739 I would love to discuss the project further :). Best, Hem

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul

Hi I've read the project description carefully. I have 5 years of experience in excel VBA, so I became an expert that fits perfectly with your requirement fields. It would be a great pleasure for me to have the opportunity working with you. ✓ Looking forward to hearing more about your project via chat. Best regards!

Hi, Dear I am VBA Expert. Recently I have done 2 Projects similar to your project. I may show that in the chat section. I can do the project 100% correct and I will complete on time. Please provide all the details related to your project. Thanks

Hi, I am vikram, read the project description. I have checked the attached automtion file. I can help you to reduce the Automation time of process by using VBA Arrays/ Dictionary. I have experience of 3+ years and expertise in Excel vba automation. Please message me to discuss more. Regards, Vikram

Hello, I use VBA on a daily basis and I always use best practices to make sure the code is as efficient as possible. Either using arrays or collection for example I’m interested in this project Thanks

I am interested to do this work ... I am very hard working and i m serious about my work ... I never do my work in the middle.I will give your work at the right time.

Hi there, I read your project I will do it I have 20+year experience in excel and ability to minimize calculation process using best vba macro coding if you assign me this project.

I have written a VBA code for a large data set. I would like you to refactor it in order to improve the execution time. For instance: - Execute the data set in an array rather than copying each individual data point - Avoiding copy and paste - Etc..

I am honestly ur work and properly done Plz give me work i want some money plz give me work plzz plzzz

I can generally compile UpTo 10 pages of notes per day. I'm interested to hear about the more project and the subjects matter of the lectures If you award me the project I'd be pleased to discuss this further and get started of you as soon as possible. Thanks!

i am ready to work with you if you give me chance i am ready to work with you and earn some extra cash