Macro to run on files in sub-folders

[dinunan]

Hi All
I've daily reports stored in multiple folders. Folder structure is like Reports/2018/01.Jan-2018/01-01-2018/two files (*.xls). Likewise for each day of the month (two files). Now I want to create one Monthly Average file residing in 01.Jan-2018 (Month Folder). I want to have a macro to run through each folder (day wise) and copy range J5:J250 of one file in monthly average file sheet1 and similar range from second file in that folder to again in Monthly average file sheet2. The next day files should update on left hand side in average file. This will bring all the data in one file and I'll be able to analyze the data in a single file.

Thanks for help!

 

[dinunan]

Hi All
is it possible to run this macro to check and fill only the remaining data. For eg, if data is already available up to 06/11/2019, then macro to loop from 07/11/2019 on wards and fill the data. Currently the macro runs for all the available sheets every time it is run.