Hello all,
I am trying to create a macro, to do this:
- macro will be placed on a new workbook, called "final". this workbook will have a lot of sheets "munchen", "wien", "paris" etc.
- when run, the macro will find the newest file in a folder , will open the file, copy some data from every sheet and paste it on workbook "final", sheet "munchen"
- after this, it will find the newest file in another folder, open the file, copy data from every sheet and paste it in workbook "final", sheet "wien"
etc etc
I managed to create something, but considering the fact that i have around 80-90 sheets, i think that it must be a easier solution
This is what i have right now...
Thank you!
Bookmarks