How to consolidate all the files into one files with different sheetnames. In a folder, there are 21 files ,how to consolidate them into one file which has diff sheetnames
- For each file in folder
- Read the data and then write to different sheets using write range…change sheetnames as per file name or numbering or as you need
Cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.