Find filename and cell position from a folder of excel files

Regular Visitor

Hello, I have an Excel file, let's call it “Master.xlsx”, with a column of numbers starting from cell A3, extracted from a folder with 10 excel files (file1.xlsx, file2.xlsx, ... file10.xlsx), each one with a single sheet of 5 columns with numbers starting from the third row. I would like the name of the excel file of the folder and the reference cell to be indicated in column B of the “Master.xlsx” file, starting from B3.

For instance:

Original data in A3 (file "Master.xlsx"):

Output in B3 (file "Master.xlsx"):
filename: file2; cell: B49

I'm using Excel 2007,
Thanks for your help.

0 Replies