I have several individual workbooks, all one sheet, ranging from 10-200 lines long, that I need to merge into one single sheet/workbook.
I've read the consolidation thread (http://chandoo.org/wp/2012/04/09/consolidate-data-from-different-excel-files-vba/) along with several others I've googled, but I'm new with VBA and I can't quite conform the code to what I need.
Suggestions? I have nearly 15,000 of these files to merge together (varying amount per merged file), so any sort of copy/paste is not really a good option.
- all workbooks are in one folder
- all workbooks are formatted the exact same way, I need cells A7:K7 for any value in A
__________________________________________________________________
I've read the consolidation thread (http://chandoo.org/wp/2012/04/09/consolidate-data-from-different-excel-files-vba/) along with several others I've googled, but I'm new with VBA and I can't quite conform the code to what I need.
Suggestions? I have nearly 15,000 of these files to merge together (varying amount per merged file), so any sort of copy/paste is not really a good option.
- all workbooks are in one folder
- all workbooks are formatted the exact same way, I need cells A7:K7 for any value in A
__________________________________________________________________
Mod edit : thread moved to appropriate forum !