Automatic print for each page

[tharikcse]

Dear ,,

I have two sheets, one with name DATA and Other INVOICE, where i've Invoice format has 10 rows to print from the values from data has 99 rows,

DATA Sheet,

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]S.NO[/TD]
[TD]CAT NO[/TD]
[TD]ITEM NO[/TD]
[TD]DESCRIPTION[/TD]
[TD]UNIT[/TD]
[TD]QTY[/TD]
[TD]PRICE[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]882-124-001[/TD]
[TD]126200005[/TD]
[TD]PRODUCT 1[/TD]
[TD][TABLE="width: 89"]
<tbody>[TR]
[TD]EACH[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 89"]
<tbody>[TR]
[TD]4485[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 102"]
<tbody>[TR]
[TD]11.025[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]545-454-545[/TD]
[TD]126200454[/TD]
[TD]PRODUCT 2[/TD]
[TD]PACK[/TD]
[TD]5458[/TD]
[TD]12.025[/TD]
[/TR]
[TR]
[TD]....[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[TD]...[/TD]
[/TR]
[TR]
[TD]99[/TD]
[TD]454-445-454[/TD]
[TD]126580025[/TD]
[TD]PRODUCT 99[/TD]
[TD]PK/12[/TD]
[TD]5646[/TD]
[TD]07.522[/TD]
[/TR]
</tbody>[/TABLE]





INVOICE SHEET - (A STANDARD FORMAT)

[TABLE="width: 500"]
<tbody>[TR]
[TD]S.NO[/TD]
[TD]ITEM NO[/TD]
[TD]CAT NO[/TD]
[TD]DESCRIPTION[/TD]
[TD]UNIT[/TD]
[TD]QTY[/TD]
[TD]PRICE[/TD]
[TD]TOTAL PRICE[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Here, i want to print the invoice sheet for the values from DATA sheet, continuously for 99 products as 10 products per invoice sheet.

How can i do this, please help .

Awaiting in anticipation,

Thanks