Hi Catalin,

Thank you for picking up this thread again.

Yes, it is tricky to get the formatting just right as the number of entries per range vary, and so I’ve changed the original format to two columns instead of three, and merged cells across the columns to identify the “range” that falls under the merged cells. If there is a prompt to manually enter the number of rows per page that might add some fixed structure for the code to work. Perhaps these changes might help revise the script?

Please look at the new sample workbook with the changes. The actually data in the output might be messed up, as this is only to show you the formatting output.

Thank you for your help,

ER