Hi Folks,
I have this file with a nice script (i didn't write myself because i'm n00b).
But it works: It puts all the excel files from a folder into this sheet.
The macro is activated by the button in the sheet Combine.
In my example, the macro already ran and it created 1. xlsx 2, 2. xlsx 2, 3. xlsx 2, 4. xlsx 2.
Now i'm stuck and i cant find a solution on internet
What i want is that it consolidates the information from these 4 new created sheets and puts them in the sheet "Consolidate".
After this, it should remove all sheets except "Combine" and "Consolidate".
Offcourse, in reality these sheets will be bigger with headers and such things. So it should copy this range. Maybe something like xl end to right.
Can somebody help me out?
Regards,
Crispy
Bookmarks