Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic line insert
Hi
Excel 2002 - I want to be able to put figures into cells going from top to bottom and have a "totals" cell at the bottom of these. When I reach the last cell to insert a figure I want another line to be automatically inserted and the formula in the "totals" cell to take account of that line insertion. Is it possible anf if so how. Any Ideas Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic line insert
Hi
not what you want but why don't you put your totals cell at the top of the column and use the following formula (if the total is stored in A1) =SUM(OFFSET($A$2,0,0,COUNTA($A$2:$A$1000))) Benefits: - no macro required (as it would be for your specification) - simple formulas -- Regards Frank Kabel Frankfurt, Germany "benosc" schrieb im Newsbeitrag ... Hi Excel 2002 - I want to be able to put figures into cells going from top to bottom and have a "totals" cell at the bottom of these. When I reach the last cell to insert a figure I want another line to be automatically inserted and the formula in the "totals" cell to take account of that line insertion. Is it possible anf if so how. Any Ideas Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if/then insert date but don't want automatic updates | Excel Discussion (Misc queries) | |||
Automatic line break in cells | Excel Discussion (Misc queries) | |||
Automatic hi-lite or shading every other line | Excel Discussion (Misc queries) | |||
Excel Automatic Date Insert | Excel Worksheet Functions | |||
Automatic Insert Row & Carriage Return | Excel Discussion (Misc queries) |