Hello Experts,
I need help on the following.
I have a masterfile.xlsx that collects data from multiple excel file that were stored in C:/Source/Week 1.
I need a macro that will open each and every excel file from C:/source and copy the content from Summary Report Sheet columns R7:W? and...