Hi I am using excel and VBA to produce an invoice.

What I have is :
Invoice No., Date, Company Name, Company Address, Delivery Address, Messages
Account Number, invoice value, blah blah blah ..

line details (upto 200 lines): stockID, stockPrice, Qty, Value

The front page of the invoice displays the summary information (no line details), and the number of pages. Subsequent pages display line details with a subtotal for each page at the bottom of the page. and a grand total on the last page.

Has anyone already done something like this? the number of lines (between 0 and 200) causes the problem, I can only think to make blank rows hide when not required. But there must be an easier way.

There is no requirement to save the invoice as an excel file, just to either print or save/fax/email as a pdf (if anyone knows how to do this, then help would also be appreciated).

I'm hoping that someone will have done this kind of one before or can send me in the right direction.

Thanks,
Marcus.