Tables in excel- bringing down formulas for new records.

  • Thread starter Thread starter Ben
  • Start date Start date
B

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.
 
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.
Click to expand...

Use a data list, as opposed to a table.
 
Back
Top