|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 16th, 2010, 06:58 PM
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
May 16th, 2010, 08:03 PM
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
May 19th, 2010, 12:35 AM
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 news  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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
