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,
<tbody>
</tbody>
INVOICE SHEET - (A STANDARD FORMAT)
<tbody>
</tbody>
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
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,
A | B | C | D | E | F | G | |||
S.NO | CAT NO | ITEM NO | DESCRIPTION | UNIT | QTY | PRICE | |||
1 | 882-124-001 | 126200005 | PRODUCT 1 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
2 | 545-454-545 | 126200454 | PRODUCT 2 | PACK | 5458 | 12.025 | |||
.... | ... | ... | ... | ... | ... | ... | |||
... | ... | ... | ... | ... | ... | ... | |||
99 | 454-445-454 | 126580025 | PRODUCT 99 | PK/12 | 5646 | 07.522 |
<tbody>
</tbody>
INVOICE SHEET - (A STANDARD FORMAT)
S.NO | ITEM NO | CAT NO | DESCRIPTION | UNIT | QTY | PRICE | TOTAL PRICE |
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 |
<tbody>
</tbody>
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
Last edited: