Completely Merge Multiple Workbooks?

D

Daystrom

I have two workbooks that are pretty complicated and totally unlike each
other, with a lot of named ranges, separate macros, user forms, etc. I want
to build a sort of "master" workbook that will ultimately replace the other
two. To get started, I'd like to merge the two other workbooks into one, so
that the one that results contains all of the sheets, the ranges, user forms,
macros, etc. of the other two. Is there a way to do this other than dragging
or copying or recreating all of the elements from the two workbooks into the
new workbook? (This is all on XL 2003.)

I'd appreciate any advice anyone has--thanks!
 

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

Top