Forum Discussion
parvares
Sep 19, 2022Copper Contributor
Find filename and cell position from a folder of excel files
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"):
23478
Output in B3 (file "Master.xlsx"):
filename: file2; cell: B49
I'm using Excel 2007,
Thanks for your help.
No RepliesBe the first to reply