wagnercardozo
New Member
- Joined
- Oct 21, 2015
- Messages
- 22
Hello everyone!
I have lots of excel files, each one saved in a separated folder, that I have to copy data from them. This is the structure I have here:
Folder Names:
15109
15115
16160
etc ... A total of 70+ folders
Each folder has a excel (with macro file):
15109 LME.xlsm
15115 LME.xlsm
16160 LME.xlsm
etc ... A total of 70+ files
Each excel file has a "SUMMARY" tab.
I want to copy what is in the cells from A8 to S8. The information there are from formulas, I need a "Paste Values Only".
The idea is to have a file called Job Summary.xlsm with a macro which will open these folders, open these files, copy the data from those cells and paste it in a worksheet called "Summary".
Unfortunately this task goes beyond my Excel skills. I need help to create this code!
I would like to thank you all in advance
Regards,
Wagner
I have lots of excel files, each one saved in a separated folder, that I have to copy data from them. This is the structure I have here:
Folder Names:
15109
15115
16160
etc ... A total of 70+ folders
Each folder has a excel (with macro file):
15109 LME.xlsm
15115 LME.xlsm
16160 LME.xlsm
etc ... A total of 70+ files
Each excel file has a "SUMMARY" tab.
I want to copy what is in the cells from A8 to S8. The information there are from formulas, I need a "Paste Values Only".
The idea is to have a file called Job Summary.xlsm with a macro which will open these folders, open these files, copy the data from those cells and paste it in a worksheet called "Summary".
Unfortunately this task goes beyond my Excel skills. I need help to create this code!
I would like to thank you all in advance
Regards,
Wagner
