use VBA to copy cells including conditional format

[lxx28]

Hi,
last time i had extremely good help with this forum and with a count.if function.

So far I have tried to make it all working, but still need a little help. Especially with macro.

In my example I want to copy rows and cells of sheet.player to sheet.print, but want to maintain te color and fontcolor (don't want to copy font size)

I was thinking of the following.
look at highest number in colom a and devide to 90.
for example highst number is 108

So 108 / 90 = 1,35, so i have to round it up to 2 to know i times i have to copy rows.

than i want to copy B:L of of PID 1 to 90 of sheet "Players" and copy sheet "Print" A2

than copy PID 91 to last PID of sheet "Players" and copy sheet "Print" M2

If i have pid of 400
it's 400 / 9 = 4,4
so 4 complete colums.
copy B:L for pid 1-90, 91-180, 181-269, 270-, 359 and the last part 360-end (pid 400)

I have attached my file, that will probably make more sense

[SPARKY347]

jesus I don't know if I'm over tierd or really don't understand, what do you want to fire the macro?, not really to sure that your trying to attempt

[lxx28]

Want to copy B:K of sheet "player" to sheet "print". But also want to copy cell color and font color.
Copy Paste wil not work, because the cell color purple will not be copied (think because of conditinal format) when I try it, thats why i think macro should be the way to go.

O want to copy 90 rows at the time and than skip a few column in "print" and copy the next 90 rows ect.ect.
Hope it's a bit more clear , forgive me with my terrible explanation.

[lxx28]

the end result should be so, that i can print a nice list on one page.

[6StringJazzer]

Closed at lxx28's request to repost on Commercial Services.