How do I make one workbook from several

A

AndrewHealy

I have over a hundred workbooks containing different data but with the same
layout / format. How can I copy them all to a single workbook without the
need to select and copy each one?
 
P

Paul B

Andrew, have a look here and see if this will help,

http://www.rondebruin.nl/sheet

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use a master workbook to carry over changes to multiple workbooks 1
Tracked changes by multiple people modified to one 0
How to make repeating drop-down lists? 2
Have 4 email addresses Want to auto forward all in one of them 0
Pasting a range to a single cell 0
Combining two sheets of data into one and sorting by value - using macros 5
Need Help with a VBA subroutine 0
Dealing with a Pivot Table (when I don't want to) 0

Top