Hello,
please see the workbook macro solution in Chandoo's web, it is a good code, however it has one problem that i need help with.
there is no column to specify the source sheet from the source workbooks.
Consolidate data from different excel files (VBA) | Chandoo.org - Learn Microsoft Excel Online
see table below, how could the Source sheet be added in the code that would exceprt the data from specific sheets listed in column D highlighted in yellow.
please see the workbook macro solution in Chandoo's web, it is a good code, however it has one problem that i need help with.
there is no column to specify the source sheet from the source workbooks.
Consolidate data from different excel files (VBA) | Chandoo.org - Learn Microsoft Excel Online
see table below, how could the Source sheet be added in the code that would exceprt the data from specific sheets listed in column D highlighted in yellow.
Excel 2010 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Item No | File Name | Full Path | Source Sheet | Data Range Start Cell | Data Range End Cell | Copy To Sheet | CopyToLocation(Start Cell Only) | ||
2 | 1 | abc.xlsx | C:\test\ | Sheet1 | $A$2 | $G$10 | MasterData | $A$2 | ||
3 | 2 | abc.xlsx | C:\test\ | Product | $A$1 | $H$50 | Sheet1 | $A$2 | ||
4 | 3 | abc.xlsx | C:\test\ | Data | $A$1 | $H$50 | Sheet1 | $A$2 | ||
5 | ||||||||||
6 | ||||||||||
List |