Dynamic Table Problem

[Jim]

I am using excel 2007. I had originally asked this question in the function
section, but VBA was suggested.

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

 

[stanleydgromjr]

Jim,

Please attach your workbook.

Click on the *Reply* button - then scroll down and see "Manag
Attachments".

 

[Herbert Seidenberg]

Excel 2007 Table
Dynamic SubTotal, GrandTotal
http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_04_10.xlsx
Pdf preview:
http://c0718892.cdn.cloudfiles.rackspacecloud.com/04_04_10.pdf

 

[Jim]

Stanley,

Attached is the workbook. Sheet 'Construction Template' has the
dynamic table. I have added the changes as suggested by Herbert,
however they are not ideal. I appreciate any suggestions you have.

Thank you,

JIM

Jim,

Please attach your workbook.

Click on the *Reply* button - then scroll down and see "Manage

Attachments".


+-------------------------------------------------------------------+
|Filename: IRDS Template.xlsm |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=514|
+-------------------------------------------------------------------+