Hey,
I'm not entirely sure this is possibly, but I would like to build a file that has a macro that examines files within a pre-determined folder and searchs for a specific tab within each file and compiles data from the same range from each file.
For example) Say I have 20 files in folder "C:\Users\username\Documents", some of the files contain the tab "MASTER", some do not. Is there any way to say, where tab "MASTER" exists in a file within folder "C:\Users\username\Documents", return all data from A9:J20000.
Example of sample file attached.
Any help would be appreciated.
Thanks!Test.xlsx
Bookmarks