Forum Discussion
Combining workbooks/worksheets
Hi Haytham--thanks for the reply! That's the way I would have originally done it, but there are going to be a large number of workbooks that need to be added.
Maybe VBA is the best way to do it?
There is already a workbook that exists with about 3 sheets and I want to add multiple excel files that are borough specific to that "master" workbook (i.e. add the workbooks as separate tabs within that master workbook).
Hi,
Please note that the link I mentioned in the previous reply guides you to three methods as follows:
- Combine Multiple Workbooks To One Workbook With VBA.
- Combine Multiple Workbooks To One Workbook With Move Or Copy Command.
- Combine Multiple Workbooks To One Workbook With Kutools For Excel (Which is a third party Excel Add-in).
You can choose the method that suits you best.
The VBA maybe the best way, but provided that the code is good, and the VBA code in that link is fairly good.
But the problem in that code is:
It's combine all worksheets in the workbooks into the master workbook, so you cannot specify certain worksheets of the workbooks to combine.
in a related question, is it possible to take the sheets from several excel workbooks to create new ones, for example;
Workbook 1; Sheet 1, Sheet 2, Sheet 3
Workbook 2; Sheet 21, Sheet 22, Sheet 23
Workbook 3; Sheets 31, 32 & 33.
What I want is;
New Workbook 1; Sheet 1, Sheet 21, Sheet 31
New Workbook 2; Sheet 2, 22, 32
New Workbook 3; Sheet 3, 23, 33.
We have a system for monitoring costs which can export data for each section to excel but in order to produce legible reports, these must be broken down and collated in the fashion outlined above; is there a way of automating this?
