Jan 10 2022 06:40 AM
Hello everyone,
I have a standard excel workbook and I am gathering information by using this standardized excel workbook. However I have to change name of this workbook when I want to collect information. The renaming parts of workbook is same.
I would like to make a master excel which can read 1000 excel which have different name but same structure from a constant folder.
Is it possible? Thanks
Jan 10 2022 06:42 AM
That could be done by Power Query using From Folder connector.
Jan 14 2022 07:14 AM
Jan 14 2022 07:58 AM
Data -> Get Data -> From File -> From Folder - select folder -> Transform -> filter if necessary - > expand Content column -> follow the wizard