Prev: Macro Message Box
Next: Excel 2007 Custom ShortCut Keys
From: Jim on 4 Apr 2010 08:19
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
From: stanleydgromjr on 4 Apr 2010 16:19

Jim,

Please attach your workbook.

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


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: 503
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192817

http://www.thecodecage.com/forumz

From: Herbert Seidenberg on 4 Apr 2010 16:43
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
From: Jim on 5 Apr 2010 00:21

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




s
t
a
n
l
e
y
d
g
r
o
m
j
r
;
6
9
0
0
7
8

W
r
o
t
e
:


>
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|
+-------------------------------------------------------------------+

--
Jim
------------------------------------------------------------------------
Jim's Profile: 1710
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192817

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Macro Message Box
Next: Excel 2007 Custom ShortCut Keys