to print specific data by button

[amarjeet.it]

Hi, i have attached a file. there are several invoices separated by empty rows. when i go to print on a single invoice on A4 paper then it makes out of order as invoice size are not same in rows, I want such code to print one empty row to next empty row on a page, then again next empty row to another next empty row on a another page, this will continue to last invoice in this sheet.. for example u can see the attachement.

[ARGK]

Hi Amerjeet
You need to insert manual page breaks between each invoice.
1. Position your cursor on the row beneath where you want the page break to appear.
2. Click on Page Layout.
3. Click Breaks followed by Insert Page Break.
Good luck.
Tony

[amarjeet.it]

hi ARGK,

thanks for your reply. but problem is i have a sheet over 10000 plus rows and i dont think to do manually is a only way if possible in macro andanother thing is only empty rows are identified as next invoices., you can also have a look in attached file. hope any guy will help me out

[jaslake]

Hi amerjeet.it

Try this

Please Login or Register  to view this content.

[amarjeet.it]

Hi jaslake,


Thanks for reply.

it's not working with attached file... please see the problem

[jaslake]

Hi amerjeet.it

That's strange...I actually tested the Code on the File we previously worked on and it performed as expected. But, you're correct, it did not do as expected on the Fie attached to this Thread.

Modified Code (tested on attached file)

Please Login or Register  to view this content.

[amarjeet.it]

Hi,
jaslake

the code you provided working perfectly.

oh thanks a lot.

[jaslake]

You're welcome...glad I could help.