Note: The other languages of the website are Google-translated. Back to English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Friday, 03 January 2020
  2 Replies
  1K Visits
0
Votes
Undo
I used the Kutools Plus feature under Workbooks &Sheets, Combine > Combine all same name worksheets into one worksheet with the options of Combine by Column, Paste values only and Insert blank column in front of each range.
Worked Great.  I then had to re-align the rows in these worksheet so that all the literals were all on the same row across each worksheet since they varied significantly, and I need
them all in the same location for a downstream import process to a database worked.

Now what I’d like to do is the reverse if that’s even possible.  Take the output from Combine> Combine all same name worksheets a combine them back into their original workbook with their respective worksheets.

Is there a feature in Kutools Plus to make this happen?  If so please show me where I can find it, if not any suggestion is welcomed.

Best Regards!
2 years ago
·
#2051
0
Votes
Undo
Hello,
Thanks for contacting us.
Sorry, we don't have such feature yet.
1 year ago
·
#2052
0
Votes
Undo
How to merge two Excel files into one by copying sheets
Open the workbooks you wish to combine.
Select the worksheets in the source workbook that you want to copy to the main workbook. ...
With all worksheets selected, right click on any of the selected tabs, and then click Move or Copy….
  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!