I have the following code that copies the same data range, J8:Q8, from 50 different workbooks in a folder and pastes those ranges to one new workbook. This process takes an extremely long amount of time and I am wondering if there is another way to write the code which would run faster.
Please Login or Register to view this content.
Bookmarks