Prometheus_au
New Member
- Joined
- Jan 26, 2005
- Messages
- 12
I have a folder with 440 files.
I would like to stack the data from B6:F30 on every file into a single sheet.
I have the VB code to do this with the data on sheets within a workbook, but now need to have the data moved from seperate workbooks.
Can this be done?
Cheers.
I would like to stack the data from B6:F30 on every file into a single sheet.
I have the VB code to do this with the data on sheets within a workbook, but now need to have the data moved from seperate workbooks.
Can this be done?
Cheers.