You can use DataForm to add new records to an existing table. It will
automatically add the formulas to the new rows.

Colin2u wrote:
is there a way to auto add rows in a work sheet when there are no more empty
ROWS to be filed and there is more work space rows needed?
i have a row with different colums with text to be filed in. what i want to
do is when i am typing in the texts and reach the end of the last row it auto
add a new ROW of the same settings as the last and if possible have my
documentation continued there.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html