Monday, 28 February 2022
  1 Replies
  6.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
2 years 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.