Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create multilined invoice (subtotals on each page)
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create multilined invoice (subtotals on each page)
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 "marcus." wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create an Invoice from a row of data | Excel Discussion (Misc queries) | |||
Force Page Break on Subtotals to Odd Page | Excel Discussion (Misc queries) | |||
how do I create invoice with fillins using again? | New Users to Excel | |||
INVOICE NUMBER WITHOUT MC GIMPSEY'S PAGE | Excel Discussion (Misc queries) | |||
In Excel, how do you create a multi page Invoice Template? | Excel Discussion (Misc queries) |