Simple question on combining workbooks.

M

madbloke

I have two multi-sheet workbooks that I need to combine (the macros need
to be combined too).

How do I do this? I know it CAN be done, I just can't remember how.
 
J

Jim Rech

Copying sheets an be done via the worksheet tab right-click menu, or by
dragging the worksheet tabs between workbooks.

You can also drag modules from one workbook to another in the VBE's Project
window.

--
Jim Rech
Excel MVP
|
| I have two multi-sheet workbooks that I need to combine (the macros need
| to be combined too).
|
| How do I do this? I know it CAN be done, I just can't remember how.
|
|
| --
| madbloke
| ------------------------------------------------------------------------
| madbloke's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=14422
| View this thread: http://www.excelforum.com/showthread.php?threadid=264637
|
 
Top