Hello everybody
I have an attachment .. In the attachment there's the main workbook which contains the code that I want to edit
The code is supposed to copy Sheet1 from all the workbooks inside the folder named "Files"
It is working but the sheets copied in descending order ... In other words the sheet names which resulted after executing the code appear as following : 7 - 6 - 5 - 4 - 3 - 2 - 1
All what I need to make the new sheets named 1 - 2 - 3 - 4 - 5 - 6 - 7
I appreciate any help
Bookmarks