How to loop through multiple files in subfolders?

  • Hello everyone,

    I have sub which I do not know how to modify in order to make it loop through files in subfolders.


    It normally loops through multiple files in a folder, finds all rows with text value "BUY" in the column M and copies that row to MasterSheet. Would be grateful for any help. Thanks in advance.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!