Thread: Tables in excel- bringing down formulas for new records.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default 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...
Reply With QuoteReply With Quote