Prev: New to VLOOKUP ...merge addresses?
Next: function to populate a cell where formula is NOT located
From: Roger Govier on 6 Apr 2010 12:41
Hi Jim

Ensure your table has a Total Row

In the row below the Total row, enter a space in column C and a space in
column D. This will ensure that you keep one blank row below your data
and the row with the tax amount.

2 rows under the Total row enter Tax in column C and the appropriate
formula for tax, being the Total value in column D * tax rate

2 rows below the Word tax, enter Grand Total in column C and the
relevant formula in column V

As you create more rows in the body of your table, the Tax and Grand
Total rows will move down accordingly (or up, if you delete rows from
the table.


--
Regards
Roger Govier

Jim wrote:
> I am using excel 2007.
>
> I want to create an invoice where the total number of line items is dynamic.
> I have created the 'header' section of the invoice with company name,
> customer name, etc and I have created the 'body' of the invoice using a
> table. This table has Qty, Description, Unit Cost, and Item Cost. Item cost
> is a formula showing Qty * Unit Cost. This table works great and is dynamic.
> As I simply type more items, the table automatically expands and formats
> correctly.
>
> The trouble I have is I want to have a Subtotal, Tax, and Grand Total line
> shown at the bottom of the table and to move as it expands or shrinks. How
> can I make these three cells move with the table?
>
> Thank you,
>
> JIM
First  |  Prev  | 
Pages: 1 2
Prev: New to VLOOKUP ...merge addresses?
Next: function to populate a cell where formula is NOT located