The best practice to print 20,000 rows of 6-columns each in pdf landscape A3

[Abdullah Qasrawi]

Hi All

I have 20000 rows as the screenshot below

my data.png

and i want to print this as 20,000 rows of 6-columns each in pdf landscape A3 page size such that the 6-columns can be repeated 3 times in each A3 page as shown in the screenshots below

result.png

actually a it will take much time if i will do this manually any advice to avoid manual work ?

Best

Abdullah

[Pete_UK]

How do you want to split the data? You could have the first third of those rows appear in the first 6 columns, then the next third in the next six columns, and then the final third in the next six columns on the right.

OR, assuming you can get 80 rows down a page, then you might want the first 80 in the first 6 columns, then the next 80 in the middle 6 columns, then the next 80 in the right-most 6 columns, all on the first printed page, and then the block of rows from 241 to 320 appear in the left-most 6 columns on page 2, 321 to 400 are in the middle, and 401 to 480 are on the right, and so on.

Pete

[Abdullah Qasrawi]

Dear pete

i want to split the data such that the first 6 columns will contain 50 rows second 6 columns another 50 rows and the last 6 columns will take another 50 rows which means the first sheet will contain the first 150 rows
then the second sheet will take rows 151 to 300 and so on. in this case i will need about 130 sheet
is there a way to do this ?

[Pete_UK]

I could give you a formula-based solution to do this, but it would be a bit cumbersome if you have 20,000 rows.

You might like to try David McRitchie's macro to produce Snaked Columns, available here:

http://dmcritchie.mvps.org/excel/snakecol.htm

Hope this helps.

Pete

[alansidman]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.