Hi everyone,
Total VBA novice here. I would like to consolidate the data stored in multiple raw files which is stored in one folder. All the raw files have the same structure and sheet names.
The items I would like to consolidate are the name of the file, cell A3, A4 and A30 in Sheet 1 of the raw files.
The expected outcome should be something like this:
Appreciate if anyone can help with this. Thanks!
p/s: Do let me know if this method is plausible using power query as well
Total VBA novice here. I would like to consolidate the data stored in multiple raw files which is stored in one folder. All the raw files have the same structure and sheet names.
The items I would like to consolidate are the name of the file, cell A3, A4 and A30 in Sheet 1 of the raw files.
The expected outcome should be something like this:
Filename | Sheet1!A3 | Sheet1!A4 | Sheet1!A30 |
123.xlsx | abc | 100 | 101 |
Appreciate if anyone can help with this. Thanks!
p/s: Do let me know if this method is plausible using power query as well
