Extracting multiple values from multiple files into a master file

[Alley oop]

I have several .xlsm files which are all formatted the same. I need to extract data from the same cells in each file to build a master table in another spreadsheet. I need the data from each file to be on one row of the new spreadsheet.

[FDibbins]

1 easy way would be to open the master and 1 if the data files, and then, from the cell where you want the answer, just reference the cell in the data sheet. you can then just copy this across to where you need to.

for the other data files, just change the file name, and repeat the above

let me know how you make out?

[Alley oop]

Thank you for your reply. I have considered that option, but I have approximately 40 separate files, and the file names not standard. I need a solution which will open each file in the directory, extract the data to a row in the master file, close the source file and repeat with the next file. This would create a new row for each file in the master file.

I have seen some code which will do this with a row, or a column, or a single cell. I need to be able to extract data from several specific cells each time. The cells are the same on every file, but they are not all in one row or column.

[Alley oop]

I have been attempting to use this code, but I have two areas of difficulty:
This code will not define the Currentfilename variable, and I have set the data range in the source book with comma delimited cell references. I do not know if that will work. Help Please!

Please Login or Register  to view this content.

[Cutter]

@ Alley oop

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.