Forum Discussion
Solved
Data Pulling - One Excel Sheet to Another From Dropdown List
Hello all! I am relatively new to Excel and I need help trying to pull data from one file to another using a drop-down list. Any help would be much appreciated! I know how to create drop-down ...
INDIRECT() works on another file, but only if such file is opened. Don't think you keep opened all 150 files.
An option could be to collect data from all files into the master sheet in another file by Power Query, and here you may sort, filter, whatever such master data.
INDIRECT() works on another file, but only if such file is opened. Don't think you keep opened all 150 files.
An option could be to collect data from all files into the master sheet in another file by Power Query, and here you may sort, filter, whatever such master data.