| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tables in excel- bringing down formulas for new records.
I am trying to put together a table and want to have an auto number that
counts the recods and puts the next number in for a new record. Need a good method to do this and to have it automatically carried down when a new record is created. I also have a formula that calculates interest on a principle amount. Neither formula will come down when a new record is created. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tables in excel- bringing down formulas for new records.
Sun, 16 May 2010 10:58:01 -0700 from Ben
: I am trying to put together a table and want to have an auto number that counts the recods and puts the next number in for a new record. Need a good method to do this and to have it automatically carried down when a new record is created. I also have a formula that calculates interest on a principle amount. Neither formula will come down when a new record is created. Use a data list, as opposed to a table. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tables in excel- bringing down formulas for new records.
To replicate formulas to new rows added, convert the range to a Table
(Ctrl+L) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Ben" wrote in message ... I am trying to put together a table and want to have an auto number that counts the recods and puts the next number in for a new record. Need a good method to do this and to have it automatically carried down when a new record is created. I also have a formula that calculates interest on a principle amount. Neither formula will come down when a new record is created. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bringing over text fields into pivot tables | Excel Discussion (Misc queries) | |||
| 2007 Excel Pivot Tables - Error Message too many records? Help | Excel Discussion (Misc queries) | |||
| Matching Records in two tables | Excel Worksheet Functions | |||
| eleminate same records in two tables | Excel Discussion (Misc queries) | |||
| excel 2003: how to match records of 2 tables according to 2 columns? | Excel Worksheet Functions | |||
Linear Mode
