Sep 19 2022 12:40 PM - edited Sep 19 2022 12:54 PM
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.