speed up excel macros

I have workbooks I use for scheduling. There are a few dozen macros that create and sort staff lists. The longest macros take 30-40 seconds on an i7 with 4gb memory. I suspect these could be written to run faster by someone who knows write better VBA macros. I use select, offset and activate a lot and I am told this is a horribly slow way to program excel. Not sure how to improve the macros.

Habilidades: Excel

Veja mais: vba and macros, excel 2013 vba, VBA Macros, speed up , sort excel, slow speed, excel speed, run faster, staff scheduling, vba chain macros excel, staff excel, excel program scheduling, scheduling excel, excel slow, knows write, speed slow, excel vba sort, program program excel, excel program write, program excel vba, vba write, qtp vba macros excel create test data, write vba, write program excel, workbooks

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #5081749

38 freelancers are bidding on average $1742 for this job


VBA developer since 1997. There are many ways of improvements when it comes to macros. Especially, after reading what you have described. However, final judgement can only be made after getting acquainted with your wor Mais

$2500 USD in 10 dias
(55 Comentários)

Dear Sir I'm happy to help you on this matter I'm one of the most trusted excel programmers in this site and have excellent ratings ;-) Please refer bellow link to see my qualifications and experience https://www.f Mais

$1500 USD in 3 dias
(70 Comentários)

Hi dmelder, I have experience in handling similar Excel macro based projects. Shall speed up the macros and complete the project within a week. Let me know and provide the Excel file containing macros. Regard Mais

$1500 USD in 7 dias
(76 Comentários)

Greetings from Easton PA.. {smile} Highly experienced [20+ years] MsExcel Business programming professional with Guru / Mentor level credentials at [url removed, login to view] and www.vbcity.com. Very STRONG scheduling Mais

$1578 USD in 9 dias
(12 Comentários)

Hi! Yes, are right. Select, offset, activate, lookups etc make the programs a lot slower. This I have learnt over the last 17 years working on excel. I use VBA extensively to make professional looking and user frie Mais

$1500 USD in 3 dias
(19 Comentários)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi Mais

$1666 USD in 10 dias
(15 Comentários)

Hello there. I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. Co Mais

$1500 USD in 3 dias
(26 Comentários)

Dear Sir This project seems interesting and doable based on my past experience with this type of problem. THE SOLUTION: ============ Some hints to speed up the code: Set screenupdating to false In sorting / Mais

$1500 USD in 3 dias
(12 Comentários)

Dear dmelder, I've great command over excel formulas, graphs, pivots, lookups na vba. I know integration of excel with txt, doc, xls, xlsx, xlsm, xlsb, xla, dat, sql server, ms access and other formats. The proj Mais

$1500 USD in 7 dias
(22 Comentários)

Hello - 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 n Mais

$1500 USD in 10 dias
(21 Comentários)

Hello, I am a VB (6.0 / .NET), VBA and VSTO software developer. I have five years of experience in programming. I see you like to update your Excel VBA program to be more faster. I can change the code to make the proce Mais

$1500 USD in 7 dias
(14 Comentários)

Hello, I am very interested in your project. I have BBA degree, management in IT, I work in sales and I am ms office/VBA expert. I can help you with your project, but would like to see your file/macros for better est Mais

$1500 USD in 5 dias
(15 Comentários)

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past exper Mais

$1500 USD in 7 dias
(8 Comentários)

Hello, I know I can help you. If you check my profile, reviews and portfolio you will see I'm VBA / Expert who really knows VBA and Excel . I'm working on freelancer only 2 months so I don't have 100 jobs done, but my Mais

$1500 USD in 5 dias
(4 Comentários)

Hi my dear, there is 4 years I work with excel vba. I have already done lot of macros using for automate the production of our statisticial yearsbook. i am ready to work with you

$1578 USD in 3 dias
(2 Comentários)

Hi! The task as you described it looks pretty straightforward and yes, most macros can be optimised simply by changing their logic (merging similar loops if possible, reducing number of IF and block IF clauses etc.) Mais

$1500 USD in 7 dias
(3 Comentários)

Hi! I understand what you need and I can help you. I have 12 years of extensive Excel experience and as part of my work at a Big-4 audit firm worked with databases of hundreds of thousands records.

$1500 USD in 3 dias
(10 Comentários)

Normally I would provide a sample to let you judge my Excel skill for yourself, but you made this a "restricted" project. I can't send you an attachment unless you send me a Private Message first. I had twenty yea Mais

$1500 USD in 4 dias
(3 Comentários)

Hi Sir, I have 4 years of excel development work. I have created excel macros for employers like you in freelancing. You can view their feedback as well. I can understand the VBA macros written by others just by Mais

$1666 USD in 20 dias
(3 Comentários)

I have vast experience with excel macros and I feel this is easily doable. I can complete the project much cheaper than $1500 - please reduce the project budget so that I can bid with the exact amount as I am now not Mais

$1500 USD in 3 dias
(1 Comentário)