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