Optimise VBA Excel code for fast execution

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

Hi, I have experience in Excel VBA, big database and extensive knowledge and expertise in stock managing on Microsoft Excel. I know to analysis databases with stock transactions to produce useful reports. and more, I can do all kind of screen layout's, reports, and dynamic dashboards on excel by formulas, pivot tables, charts, and VBA. I am a specialist in financial reports, budget, costing reports, inventories, bill of materials together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports showing the relevant information in dynamic dashboard and graphs. Throughout my career, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a range of products and services. Areas of expertise: • Developing of consolidated financial statements, financial plans (fitted to due diligence), feasibility studies, and measurement reporting tools for global companies • Business valuation (NPV, IRR, DCF, MCDA, CPI, SPI, EVM) • Budget Development & Management • Implementation of information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, MF, ERP, Venture Capital system, CRM, etc.) • Business expansion and start-up • Served as CFO, Controller, and Chief Accountant at global parent companies • Extensive experience in accounting, cons

I have checked your file and it is pretty straightforward. but why run a loop for each cell while the calculation can be done with native functions? And there are very basic things for VBA optimization (like turning screenupdating and auto calculations off etc.) I can make this code much faster and I am happy to fully reund you if you are not happy with the results. Lets discuss more at chat.

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards

Hi, I am an Excel macro expert and would be happy to take on your project. Let me know and we can discuss. Regards, Arul

I can do it for you quickly and exactly .

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/

Hi Please communicate.. I can do that .. I was expecting communication from your end.. Thank you..

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 75 projects, almost 70+ are complex VB/VBA/.Net/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.

I'm a Microsoft certified professional with over a decade experience

Hi, I am see your file and interested for you project. I am able to hard work and I guaranteed that you will fully satisfied after hiring me. Thank you -Sajib

A proposal has not yet been provided

Hi there, if you'd like to have a professional Ms Access/Excel automation DB, here is my introduction: I’m an Access/VBA coder, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You can have a little view about my coding experience.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura

Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov

Programmer with more than 10 years of experience in VBA. Best quality work guaranteed.

I have the expertise in Excel and can optimise the attached code for performance. Ready to start work immediately.

Hi Iam here Sir I think thats not evident for a programmer to change the code of another one its more difficult than creating a new one contact me and lets discuss dore Thanks

Hello there - I am an Excel Genius so I can get Excel to do whatever I need it to do. I am also a native English speaker so nothing will get lost in translation. I have looked at your provided file and it is inefficient as you have noticed. Do you have an actual textual description of what you are trying to achieve? I could reverse engineer it from the code but I like to "hear" what you are trying to achieve so I can match that with the best way to achieve your target. You are populating a sparse table but iterating through all the cells - I would consider going the other way = clear all the cells and only populate the full ones? It also looks like you are pivoting the data from UID_RAW to BULK_SITE? Handling large data sets and processing them is something I can handle quite simply, leveraging the power of Excel worksheet functions and VBA together to make it fast. I would love to discuss this with you and ensure that you get the result that you need - drop me a line and we can chat over the phone to get you what you need. I won't promise you a given time saving but I will tell you that I can make it as fast as it can be! Hope you find the right freelancer. /R.

Dear future employer, I apply because I am a perfect mix of experience and value for this project! I am a 3yr-experience bachelor telecommunications engineer who have worked for 11 months as an Excel data analyst in a venezuelan drilling contractor. In my position, I constantly create, manage and optimize Excel files and databases requiring me to apply my knowlegde and skills on VBA programming In these terms, I know how to improve VBA performance by reducing CPU usage, being able to achieve speeding up of a file even to 10x faster by using array-oriented searches and calculations, as well as single-time reading/writing operations due to the delay they produce. Also important is to mention that I am able to deliver the product comfortably within any deadlines agreed on interview with the highest achievable quality. Looking to hear from you soon Eng. Jesus Gonzalez Canas P.S.: I am available now for discussion. Also, attached is sample picture of some recent VBA work of mine.