Macros for worksheet copy & paste?

W

Wendy W

I have 6 different excel files. How can I combine all 6
of them in one single excel file under individual
worksheets (E.g. Worksheet1 for File1, worksheet2 for
File2 ....etc)? I do not wish to copy & paste it
manually. Can I use a macro to take care of it? If so,
where can I find further info on how to go about it?
THANKS!!
 
J

J.E. McGimpsey

Assuming (1) this is a one-time need, and (2) your workbooks have
only one sheet each, this would probably be faster done by hand:

1) With all the files open choose one of the files to be the
receiving file.

2) Select the sheet in the subsequent books, one at a time, and
choose Edit/Move or Copy Sheet...

3) In the dialog that opens, choose your destination book from the
dropdown (you can also choose to create a new book). Select the
postion in the destination book that the sheet should be copied to.
Check the make copy checkbox if you want to leave your original
files intact.

4) Save your combined book.
 
Top