using Power Query: Break a long, filtered, list of items into 60 rows on required number of sheets

[BasicUserWithExp]

I posted previously about VBA to do the same thing however; i found out i couldn't use VBA in my work files.

I found a way to use power query to create a table with filters. It works but i am unsure how to use the filter to count the rows, so only 60 are per page. Dropbox

 

[Kaper]

You may use helper column with your FIND column divided by 60 and rounded down . (If your real FING is not starting from 1 you may add index columnand use it instead.
then filter just one page number and delete no-longer needed page column. So the code would be something like:

    RoundDown = Table.AddColumn(PreviousStep, "Page", each Number.RoundDown([FIND]/60)),
    FilterOnePage = Table.SelectRows(RoundDown, each ([Page] = 0)),
    DeleteHelperColumn = Table.RemoveColumns(FilterOnePage,{"Page"})

and of course then you may edit FilterOnePage step (click on a small gear next to it and select next page number, or simply change this number in formula bar)