Tables in excel- bringing down formulas for new records.
in [Functions]
|
From: Ben on 16 May 2010 13:58 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.
From: Stan Brown on 16 May 2010 15:03 Sun, 16 May 2010 10:58:01 -0700 from Ben <Ben(a)discussions.microsoft.com>: > > 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...
From: Ashish Mathur on 18 May 2010 19:35
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" <Ben(a)discussions.microsoft.com> wrote in message news:DA82272B-53EE-4BF3-9F74-3E786201876E(a)microsoft.com... > 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. |