Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, February 28, 2022
  1 Replies
  7.3K Visits
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.

2 years ago
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.

You can follow the dialog boxes, or if you need a tutorial, please click here:

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

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