LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Dynamic Table Problem

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic chart problem hoyos Excel Discussion (Misc queries) 0 October 7th 09 09:46 PM
dynamic range with a table below the working table Robert H Excel Worksheet Functions 9 March 17th 08 01:41 PM
Dynamic hyperlinks problem Mr.Plankton Excel Worksheet Functions 0 June 21st 06 03:20 PM
Dynamic range name problem [email protected] Excel Discussion (Misc queries) 2 September 23rd 05 12:52 AM
problem with dynamic graph [email protected] Excel Worksheet Functions 1 April 11th 05 07:30 AM


All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"