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

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

On Mar 27, 6:47 am, "nickm687" wrote:
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