split data in to multiple sheets in same excel

[Anjankumar2021]

Input file contains  20k rows with 5 columns. required output is only 999 rows should be in 1 sheet. and we need to split into remaining data into sheets in the same excel

Pls assist

[BS_THE_ANALYST · Accepted solution]

@Anjankumar2021 
1. Attach your file to this workflow. 

2. On the Output Data tool. Change the file path to where you want to save the new excel sheet.

Note: inside the formula tool, you can change the number to whatever you want. This number determines how many rows you will get per sheet inside the excel file

[Anjankumar2021]

Thank you so much and its working without any error :) 

[BS_THE_ANALYST]

@Anjankumar2021 You're very welcome 😀.