How to Use Merge Workbooks?
»
Let's say you have your monthly budgets in seperate Workbooks and you want to combine those workbooks into one workbook. You can use Merge Workbooks to quickly and easily combine those workbooks into one workbook.
|
Note
»
Macros can't be undone. Backup your work before running any macro.
|
Step One
»
Open MergeWorkbooks.xls.
NOTE: When opening the workbook you may or may not have been prompted to disable/enable macros. You will need to enable macros for the macro work. If you clicked disable when opening this workbook, simply close this workbook and reopen it enabling macros.
Click here for more information regarding Macro Security.
|
Step Two
»
Click "+" and select the Workbooks you want to combine. (See Figure 1)
(Figure 1)
|
Step Three
»
Click "Start"
|
Result
»
Figure 2 shows the new workbook created with the worksheets from the workbooks selected in step 1.
(Figure 2)
|
The macro doesn't run, What is wrong?
»
If the macro doesn't even start it could be because the security settings in Excel are too restrictive. I suggest setting the macro security on medium. This will prompt you to choose between enabling and disabling macros in a workbook.
Click here for more information regarding Macro Secuirty.
|
Frequently Asked Questions
»
Click here for more information about Merge Workbooks.
|
Download/Purchase
» There are two editions of Merge Workbooks. Both editions will combine multiple excel workbooks into one workbook. The professional version includes some additional time saving options. Only Merge Workbooks Professional has been tested and is supported in Excel 2007. See the comparison table below:
|
|
Features
|
|
|
Combine multiple workboooks
|
|
|
Ability to skip blank worksheets
|
|
|
Microsoft Excel 2007 Compatible |
|
|
Save the list of workbooks
|
|
|
Ability to include hidden worksheets
|
|
|
Enhanced support for xls files created by Third Party software
|
$19.95 |
$9.95 |
Price USD |
|
|
The trial versions are limited to merging up to 5 workbooks.
|
|
|
|
After the payment process is complete, you will receive a serial number via email to unlock the shareware limitations.
|
|
