Export and Merge Excel workbooks (Excel Add-In) ($ 47)
(please leave your e-mail address upon payment and you’ll receive your Add-In in up to 3 days)
See movie…Export and Merge Excel files (new functionalities added)
Download Demo file and try before you buy: Excel Export & Merge_ver_1.97_DEMO
You can use sample file to test this Add-In: Excel_Export_and_Merge_Sample_file
Demo file is restricted to export up to 3 files (3 unique elements in particular table field) or merge up to 3 files from particular folder.
After installation, new tab will appear on the Ribbon (Export and Merge)
(e.g. select cell D6 or E6 in a table to start export, then try merging data by choosing folder where exported files were put and try importing/merging)
Create Excel worksheets or workbooks from data in main table according to chosen criteria (AutoFilter) and then merge them back from several workbooks.
This Add-In has two main functionalities:
Export worksheet’s data according to chosen criteria (new sheet of data for each unique value in source table filter list)
- To new workbooks (each unique element from filter in a source table represents data exported to new workbook)
- To new workbook (each unique element from filter in a source table represents data exported to new worksheets)
- To new sheets in active workbook (each unique element from filter in a source table represents data exported to new worksheets)
Merge data from workbooks in specific folder to one worksheet in active or new workbook
- To new workbook
- To active workbook (to new sheet)
- From sheets in active workbook to new sheet
Why would you use it?
It could be very useful when you have to export data e.g. to new workbooks according to criteria, so that each recipient can work with it’s own workbook, make some changes (additional information) in table and then you can merge all these data from workbooks in specific folder to one workbook. Usually these workbooks are placed on some company’s shared drive. It’s quite fast and it could save you a lot of time if you have to create many files from main table and then again you have to merge them after they were processed.
You can buy it for $ 47
There are no limits regarding number of worksheets to be exported neither workbooks to be merged. Of course, in case of bugs you will get fixed version as soon as possible. All your suggestions regarding new functionalities are welcome.
Your feedback, comments and suggestions are appreciated. With your input this product can become better!
drazen (at) excelalacarte (dot) com
This version can be used in Excel versions 2010 and 2007. After download, please save the Add-In to some location on your disk.
- Excel 2010 version
- File, Options, Add-Ins, Go (Excel Add-ins), Browse… after click next to Excel Export & Merge, new tab on the Ribbon will appear at the end
- Excel 2007 version
- Office button, Options, Add-Ins, Go (Excel Add-ins), Browse… after click next to Excel Export & Merge, new tab on the Ribbon will appear at the end
No software product is free of bugs and problems, and although this one is no exception, there is a significant difference: you will get timely answers to your questions (typically within 24 hours) and you will get frequent new builds with bug fixes.
Thank you and enjoy Exceling 🙂