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!
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!