create multilined invoice (subtotals on each page)

[Guest]

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.

 

[Bernie Deitrick]

Marcus,

Sounds like you could use Filtering to show the data that is relevant.
Select a single cell in your table, use Data | Filter | Autofilter, then use
the dropdowns that appear next to each table heading to select the
appropriate values prior to printing.

As to saving to PDF, you need software (I use PDF995, which works well and
only costs $9.95), and once that software is installed, you simply choose
the PDF option that will appear within your list of printers.

HTH,
Bernie
MS Excel MVP

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).