merging workbooks

[sunroyal]

Is there a quick way to merge workbooks?

Either by merging open workbooks or by merging them before they are
opened?


Thanks in advance and Happy Holidays.
Lane

 

[Dave Peterson]

To get a real answer, you're going to have to be more specific.

Does merge workbooks mean:
1. Copy all the sheets in several workbooks to new workbook (so it ends up with
lots of sheets)

2. Copy the data from all the worksheets in several workbooks to a single
worksheet in a new workbook

Either way, are the workbooks to be merged in one folder? Is that folder
dedicated to just the workbooks that need to be merged? Or do you have some
naming convention that needs to be looked at to see if it should be merged?

===

Manually, you could do each of these things pretty easily--but with lots of
workbooks, it would get boring. If you need to do it lots of times, a macro
would make life simpler--but that macro needs a little more specification.

 

[Guest]

I use the ASAP add-in, its free to download and has lots of helpful features, including merging workbooks into one or into separate worksheets: www.asap-utilities.com

Stephen B


----- sunroyal wrote: -----

Is there a quick way to merge workbooks?

Either by merging open workbooks or by merging them before they are
opened?


Thanks in advance and Happy Holidays.
Lane