Tables in excel- bringing down formulas for new records.

[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.

Thanks.

 

[Stan Brown]

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.

 

[Ashish Mathur]

To replicate formulas to new rows added, convert the range to a Table
(Ctrl+L)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com