View Single Post
 
Old 12-11-2016, 05:05 AM
abbani abbani is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Feb 2016
Posts: 11
abbani is on a distinguished road
Default How to copy workbooks from different worksheets into one new worksheet

In one directory, I have 100 worksheets each with one workbook (Sheet1).
I want to copy every workbook from all 100 worksheets into one new worksheet.
Is this possible?
Thanks.
Reply With Quote