Hi Experts,

I have data around 100k in column a & b and would like to print all of them which will be more than 1000 pages.

In order to reduce the number of pages to around 63, I have to adjust 1,580 rows of data in a single sheet (1,580*63=99,540)

Appreciate if somebody could provide me VBA/Macro to cut the data after every 158th row and past next to a&b, d&e, g&h and so on until the entire data is adjusted next to each other with maximum 158 line of data.

FYI, the font size will be decreased to 7 and the adjustment of scaling will be 57

Thanks for your support