A picture tells a thousand words. This is what we want to achieve. It is only “kind of” a paginated report because it works only on the application (Excel) but not for printing. 😅
With dynamic array and new functions in Excel 365, this task is not difficult at all. Only two functions involved. They are CHOOSEROWS and SEQUENCE functions. The spin button is not something new. It’s been in Excel for too long. Just that you may not have a chance to use it before.
Let’s watch it in action.
You may download a sample report to follow along.