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!


Please Login or Register  to view this content.