I'm new to Excels advanced feature so apologies if my question is a noob one.
Similar task might have been addressed already, but I couldn't find a solution to my specific issue.
I am trying to collect data from multiple files:
- All files are in the same folder
- Files share the same naming convention (report 01-07-2015.xlsx, one for each day of the month)
- The sheet I need data from are the same name (Report) and structure is also same in all files.
- From each files' 'Report' sheet, I need the values of C1,D1,E1,F1 cells, populated into different rows in the destination file, based on a reference value(A5) from the destination file.
- All sheets contains the reference value I want to refer to from my destination file.
I've tried with Vlookup, but I don't want the files to be opened... Found also a 3rd party add-on (morefunc - indirect.ext function for the file names) that would be perfect, but since I am using Excel 2013 64bit, I cannot use that.
Any suggestion would be much appreciated.
Thank you!
Bookmarks