All Questions
4
questions
4
votes
1
answer
192
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
337
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
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
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