Excel VBA General Improvements - Mainly speed, efficiency and structure

Hi, Can you share the code with me? I would like to review the code to judge the requirements of cleaning/speedup. I am expert in Excel VBA with over 7 years of experience.I have completed over 150 Excel/VBA related projects on this site. Thanks

Dear Project poster, I understand that you want to enhance the feature of existing macros through excel programming or VBA. I have 5 years of experience. I have good knowledge of excel. I am looking for projects. I can complete your project with in 1 day. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet updated. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).

Can you share your file so I look at it to talk more accordingly. Thanks.................................................

Hi, Please send me the excel file. 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 generator reports showing the relevant information in 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 applications, 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, consolidating, forecasting, budgeting, and costing • A systemic perspective and ability to lead financial, organizational transformation of a company • Excellent awareness of the service and human relations

i can do it for you quickly and exactly

Hi Sir Ryan, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

Hi, Please suggest good time to have further discussions on the requirement. I am well versed with VBA. I have used VBA extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 10 years of experience to my credit. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder

Hello :) Greetings for the day!! This is Sourabh Gupta from New Delhi. I am an advanced VBA programmer. I read your description stating that you need to revise the existing macro you have. I would like to offer my services for the same. I will improve the speed of your code significantly by using better and faster techniques and eliminating unnecessary loops. We could also replace the traditional methods by new faster methods without compromising the accuracy of the output. If you could message me once and give me an opportunity to do the job. Just message me once. Then we can provide me with the macro you have. Then I would study and revise it to increase its speed. If you are satisfied with the new macro you may buy it, else no compulsion if you dont like it. Do consider me once. I wont disappoint you. Will wait for a prompt and positive response from your side :) Regards Sourabh Gupta

I am a Data Analyst with over a decade of experience working with VBA. I can have the project completed within 24 hours of accepting. I look forward to working with you soon!

I can start working on it right away if you award the project to me now. Pretty much sure the reason why the macro runs slow is because of some unnecessary loops.

please send me the excel file which needs to be improved, so that I can do some rough work and give you approx timeline of completion Hi, I will complete this task in few hours We can chat before you award me this project You can pay me after I have delivered you the working file Looking forward to hear from you Thank you

HI employer. Can i have a look for your files? I cant say i can do it or not if i dont know which file is and the formula is. Can we chat for more information?

I have a lot of experience on doing automation that can reduce work hours, collating multiple files, dump data to databases, etc. I can be a great help on your project. Please visit my portfolio for some of my dashboard/project done.

I have many experience with VBA and I ranked 5th in the Excel worldwide competition organized by Certiport and Microsoft in 2015

Hello Ryan, I am a new freelancer with IT education background, therefore this task should be completed with ease. At my previous workplaces I have over 3 years of experience of building up automation macros. I also need to build a good reputation on Freelancer, so you can count on me for doing a great job. Please let me know if we can discuss further details. Would love to improve your code. Cheers, Orsi

A proposal has not yet been provided

Expert in VBA. Trained VBA developer on code performance and clarity.