Main Area and Open Discussion > General Software Discussion
Merge or combine worksheets from the same excel workbook
Shades:
Perhaps it is an idea to export everything into CSV files, combine these text-based CSV files into one and then import the result back into Excel again?
Still, that requires the content of each sheet to be the same as the others.
Exporting everything to CSV should be easy enough with Excel itself. You could use join software for combining these CSV files. Once done with that, you can then use the CSV import functionality from Excel itself to get one worksheet with all the data in a new Excel file with an appropriate name.
Unless there is a need to keep formulas etc. exporting to the simplest data format, using one of many free join software programs to create one big file and then importing this file onto a new Excel file, seems the best way of tackling Contro's problem. To me, at least.
Target:
if all the sheets are in the same format (all columns match and all formulas are the same) then you're only copying the data (the calculations can be done in the target sheet)
The simplest way to do this for a one time job is to copy + paste - it would have been done in less time than you've spent on this thread
if you need to do this often (ugh...), then its not as simple as just finding an addin. Every situation is different and you have to make sure the data is clean before you even start (else you just end up with garbage)
Ath:
@Contro:
Ok, I'll ask the 'big' question once, and please don't repeat the confusing flurry mesh of info you gave above: What goes into this black box, and what is the expected output? (IOW, what is it to be used for)
Contro:
Perhaps it is an idea to export everything into CSV files, combine these text-based CSV files into one and then import the result back into Excel again?
Still, that requires the content of each sheet to be the same as the others.
Exporting everything to CSV should be easy enough with Excel itself. You could use join software for combining these CSV files. Once done with that, you can then use the CSV import functionality from Excel itself to get one worksheet with all the data in a new Excel file with an appropriate name.
Unless there is a need to keep formulas etc. exporting to the simplest data format, using one of many free join software programs to create one big file and then importing this file onto a new Excel file, seems the best way of tackling Contro's problem. To me, at least.
-Shades (February 08, 2020, 06:38 PM)
--- End quote ---
Shades I was thinking in an ahk script.
I am doing manually.
If you export to csv you have a txt plain text.
I finally make work the rdbmerge utility to see that change everything.
It's clear that excel is a "big" program. But perhaps one that have traumatized me in the past like Autocad, microsoft word and some technical software. And of course windows xp pro traumatized me a lot.
I am applying manually from each worksheet the usual or standard copy/paste excel have with no problem.
So perhaps a little script with autohotkey may be useful for me.
I am thinking visit the code snack section.....
:-* :P
Contro:
if all the sheets are in the same format (all columns match and all formulas are the same) then you're only copying the data (the calculations can be done in the target sheet)
The simplest way to do this for a one time job is to copy + paste - it would have been done in less time than you've spent on this thread
if you need to do this often (ugh...), then its not as simple as just finding an addin. Every situation is different and you have to make sure the data is clean before you even start (else you just end up with garbage)
-Target (February 09, 2020, 03:22 AM)
--- End quote ---
Target you have a good nick.
I have done manually, but if I don't put the post how we can enjoy talking about software ?
If I merely search in Father Google how can I share with human sensitive persons my inquietudes ?
:Thmbsup: :-*
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version