Note: The other languages of the website are Google-translated. Back to English
  Monday, 28 February 2022
  1 Replies
  3.1K Visits
0
Votes
Undo
Is there a way to use the Split Data into Multiple Worksheets within the same Workbook?
I need all the data to stay in the original Workbook.

Thanks
9 months ago
·
#2487
0
Votes
Undo
Hi Dave_Williams,

Sorry that with the Split Data feature, the data been split would go to a new workbook.

However, you could use the Combine feature to combine all the sheets from different workbooks into one workbook after you apply the Split Data feature. To access the feature, please go to the tab Kutools Plus, in the group Workbooks & Sheets, find Combine. Then click the third option in the pop-up window.
  combine.png

You can follow the dialog boxes, or if you need a tutorial, please click here: https://www.extendoffice.com/product/kutools-for-excel/merge-excel-wordbooks.html

If you have any other questions, please don't hesitate to ask me.

Amanda
Attachments (1)
  • Page :
  • 1
There are no replies made for this post yet.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL