Hi everyone,
I've come to an issue, when I have to combine data from several hundreds to thousands Excel worksheets to one for easier processing. The macro works on one PC, but the thing is, that when I try to use it on a PC with much much better HW in every way, it is like at least four times slower or experiencing errors that set the macro processing into debug mode.
For the description what the macro should do:
It is given a path to a directory. In this path there are many other directories which are to be gradually opened and inside the directories there are 5 to 10 excel workbooks from which the several columns of data are to be copied to a new worksheet named by the folder name. Also there is a part that finds maximal value and sum of the values and gives it to a place which is easy to find and copy from.
I have also tried to speed up the macro to be as fast as possible, but I am not sure if everything written down is actually helping to speed it up or even necessary.
If you could help me to make it work correctly or even to further optimise it, I would be very grateful.
Bookmarks