#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Yes
try http://www.rondebruin.nl/win/section3.htm or http://www.rondebruin.nl/win/addins/rdbmerge.htm
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thank you Pecoflyer.
It was helpful. |
#4
|
||||
|
||||
You're welcome
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combining different worksheets into a single worksheet. | jimmy2016 | Excel Programming | 4 | 10-15-2016 09:05 AM |
copy cells from a worksheet into other worksheets based on Criteria | Elton Wolter | Excel Programming | 4 | 04-16-2016 08:44 AM |
Linking Workbooks/Entire Worksheets to Identical in Master | taxacct | Excel | 2 | 10-01-2014 11:22 AM |
Can you copy & paste cells across worksheets and preserve reference to worksheet? | New Daddy | Excel | 2 | 11-27-2013 07:19 AM |
VBA: Creating new Worksheets from two different Workbooks | Johana | Excel Programming | 1 | 09-07-2012 09:30 PM |