All Questions
11
questions
-1
votes
1
answer
51
views
Need assistance modifying a "too large" procedure [closed]
I have a chunky VBA script that needs some help making it efficient, which I think will correct the "Procedure too Large" issue I just ran into.
I run the procedure from an open workbook ...
0
votes
1
answer
62
views
Code compares Columns "A" of two workbooks and copies different information to destination workbook with entire selected row. LastRow count slows code
Code explanation:
I have a code, which performs two tasks -
To open two workbooks, one being extract info and one destination and it compares the column A with Column A of these workbooks and all ...
- 3
4
votes
1
answer
191
views
Optimizing a large report sorting macro
I've been working on this project for my organization for a few months now, and am looking for ways to increase performance on this macro.
I work for an insurance company as a claims auditor. I get a ...
0
votes
2
answers
336
views
Improving Speed of VBA Code - Copy/paste two sets of variable, Excel does a calculation, returns a value then copy/paste the output value
I am attaching the code here. I am very new to VBA and trying to do a complex calculation using Macro. Please help me improve the speed of the attached code. The code works fine and produces the end ...
- 3
3
votes
2
answers
103
views
internal links b/w sheets of merged workbooks, using VBA (EXCEL MACROS)
My aim is to merge all workbooks having multiple sheets from any specified folder to one workbook of multiple sheets. The problem is I don’t want external links to be maintained, If I use "...
3
votes
1
answer
139
views
COVID model using UVA data
I have built a COVID model using UVA data. Currently that data is unavailable so I'm using another source. The new source is, of course, a different format. So rather than refactor all of my model ...
- 133
4
votes
2
answers
111
views
Time axis with working days, weeks numbers, month-year
I made the bellow macro to create a time line in excel.
It shows the working days, the week numbers and the month together with the year.
First I start with projectstart date and projectend date.
As ...
- 41
1
vote
0
answers
129
views
Optimizing VBA code , Takes more than 50 minutes to update
Could you please help me optimize the macro, Its taking more than 50 minutes but still no success.
The For loop is looping untill 1.0 million + rows.
Screen is flickering.
I have tried Application....
- 11
2
votes
2
answers
235
views
Index Match implementation
The code below takes header variables, retrieves the column index, and then, using an Index/Match function, returns data from a matching account number.
The reason it is written this way is because I ...
- 131
0
votes
1
answer
386
views
Increase the execution speed of VBA macro code
I am providing you with the code of my macro and hope that somebody can tell me what is making my macro slow and provide me with a solution as to how to make it run faster. Currently the execution of ...
- 11
3
votes
1
answer
3k
views
Speed up Excel Macro b/n copy and paste external files
I posted on the Stack Overflow. They recommended me to post on here
So the whole scope of this Excel file is to copy and paste from other 27 external files to the current Excel file one by one. to ...
- 33