Merge or combine worksheets from the same excel workbook

ATTENTION: You are viewing a page formatted for mobile devices; to view the full web page, click HERE.

Main Area and Open Discussion > General Software Discussion

(1/4) > >>

Contro:
I have 13 sheets in an excel workbook. Format xls.
I want to join, merge or combine the 13 sheets in only one.
I have tried to select all but moving or copying give not the target.
How can I do that with a free utility ?
Best Regards
:-* :P

a worksheet merger utility from the same file or excel workbook.

Note : I have tried two utilities from vba code in commercial pages, but don't work. So I would the correct code with no problems.
Note : I am trying to find here : http://www.rondebruin.nl/win/addins/sectionaddins.htm , seems not commercial.
:-*
Note : http://www.rondebruin.nl/win/addins/rdbmerge.htm
There are two versions depending of excel version .
:P
Note : I obtain automation error with the addon and occurr an exception.
then open excel 2010 again and nothing....

So I need a good addin for the occassion or use well the The Ron The Bruin addon

Note : To avoid confuse Ath or any other helper I am trying to determine the exact target to get :

Consolidate in Excel: Merge multiple sheets into one

Merge several excel files in one is done well with https://products.groupdocs.app/merger/xls

All my worksheets have the same configuration or formulas.

The target is :
Condensing Multiple Worksheets Into One (Microsoft Excel)

Note 08.02.2020.19.50 : trying this
https://excelribbon.tips.net/T008884_Condensing_Multiple_Worksheets_Into_One

Note : 08.02.2020.20.01 I tried. No good result. So probably the xls files components and threrefore the worksheets have not the same structure.

I must do manually with the old method copy/paste.
Best Regards

Ath:
1 google search gave me enough information to find this makeuseof page (select Not Now in the red page-blocker when using a decent browser with an ad-blocker), providing not 1, but 3 step-by-step procedures to accomplish what you ask. With the standard product, so no utilities needed, only a rather simple skill: google

As you forgot to mention what Excel version you are using, I assume you have a decently modern version that has a ribbon (Excel 2007 or newer).

Contro:
1 google search gave me enough information to find this makeuseof page (select Not Now in the red page-blocker when using a decent browser with an ad-blocker), providing not 1, but 3 step-by-step procedures to accomplish what you ask. With the standard product, so no utilities needed, only a rather simple skill: google

As you forgot to mention what Excel version you are using, I assume you have a decently modern version that has a ribbon (Excel 2007 or newer).

-Ath (February 08, 2020, 11:30 AM)
--- End quote ---
The link don't do what I ask.
Use the copy/move option that is not enough to merge sheets in one sheet.

I use a online utility Free Online xls merger that works fine to merge xls files in one file converting every workbook in a worksheet in my example (just because each workbook only have one worksheet). So I obtain a single xls with a 13 sheets.

The difficult point is get a new workbook with only one worksheet obtained from the previous 13 worksheets.
And in this point the native excel utility is not enough.

:-*

Note : this is the merger online to group several xls files in one single xls with worksheets created from the original workbooks : https://products.groupdocs.app/merger/xls

Contro:
What I simply need is an utility able to combine the worksheets from a single workbook into a new one by the the method of copy/paste.
Not considering structures or data, only copying from one worksheet to the combined one by order....

:-* :P

Navigation

[0] Message Index

[#] Next page

Go to full version