Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic chart problem | Excel Discussion (Misc queries) | |||
dynamic range with a table below the working table | Excel Worksheet Functions | |||
Dynamic hyperlinks problem | Excel Worksheet Functions | |||
Dynamic range name problem | Excel Discussion (Misc queries) | |||
problem with dynamic graph | Excel Worksheet Functions |