Removing column borders from an invoice
Tech-Archive recommends: Speed Up your PC by fixing your registry
Before I use a macro to insert totals into an invoice I need to remove the
continuation borders of the template otherwise the macro assumes that the end
of the border is the end of the invoice. Column A has the items, B the
quantity, C the unit price, and D the total. The invoices can run from A1 to
A600 being different each time. Can anyone please help?
.
Relevant Pages
- Re: Removing column borders from an invoice
... > Before I use a macro to insert totals into an invoice I need to remove the ... > continuation borders of the template otherwise the macro assumes that the end ... > of the border is the end of the invoice. ...
(microsoft.public.excel.programming) - Re: Newbie, Help needed with rounding errors
... This is why tax should only be computed on the sub-grouped total values, ... The Revenue's method of subtracting the computed price net of tax from the ... price per item on the invoice, so I round to get 21.57 each. ... incorrect totals." ...
(microsoft.public.access.gettingstarted) - Re: Formula selection: a real tough one
... I misread the OP saying he wanted the Invoice TOTAL, where Item SYSTM was included. ... The totals will be just for that Item. ... Drag Item No to Page area ...
(microsoft.public.excel) - RE: SubTotals on Forms
... No. SubForm 3 draws on the invoice query and only has two items on the ... I want to have two totals at the bottom of the ...
(microsoft.public.access.forms) - Re: report group subtotals incorrect
... there are multiple payments of the invoice, ... This text box accumlates the total for the customer over their invoices, ... An alternative idea would be to use a subreport for the payments. ... > tehn totals per group. ...
(microsoft.public.access.queries) |
|
