Split Big Excel file into small chunks by ensuring last entry doesn't get into two sheets

[SekharSai1993]

Hello Alteryx Community,

I have approximately 40,000 line items that I need to split into files with 500 entries each. While doing this, I need to ensure that the last entry of each file is not duplicated in the subsequent file.

For example, if I want to split a file of 25 entries into 3 files with 8 entries each, setting the Max Records for the file in the Output tool would cause "My User - 2" to appear in both the 1st and 2nd files, which I would like to avoid. Given the large number of line items, manually checking is impractical. Could you please advise on how to split the files without having the entries of same user in multiple files?

Thank you in Advance!!

[Qiu]

@apathetichell 
Thank you very much for the support.
happy holidays.

[apathetichell]

@SekharSai1993 ---> test my workflow and then mark it as the solution when you get a chance.

[SekharSai1993]

Thank you for providing the Workflow. Although I am not great at using the Macro's, but the Formula of Floor within the Macro helped me understand how to retrieve entries split across two different files when using a divider such as 500.