Merging Workbooks

[nickm687]

Hi,

Is there a way to automatically merge workbooks, for example using
macros.

I would like it so i could have four reports (workbooks) lets say,
that will merge into one workbook.

Thanks in advance.
Nick

 

[Susan]

nick -
well, yes, but you have to figure out a lot more details than just
that.
does each workbook contain only one worksheet?
do you simply want a copy of each worksheet combined into one
workbook?
do you need a summary sheet with that?
or do you want it all combined on the same worksheet?

first you have to figure out what you WANT before you can figure out
how to do it. altho, perhaps you already know & just didn't write it
here..

susan