automatically apply formula to new row
 

I have a spreadsheet that requires the constant addition of new rows
of data and I need the sheet to automatically recalculate the desired
totals to include the new row. I am fairly new to macros and was
seeking some basic direction on how to program this.

automatically apply formula to new row
 

Insert before the last row in your formula
or
create a defined name
or
=SUM(A2:OFFSET(A2,MATCH(9999999,A:A),0))
--
Don Guillett
SalesAid Software

"CrazySwayze" wrote in message
ups.com...
I have a spreadsheet that requires the constant addition of new rows
of data and I need the sheet to automatically recalculate the desired
totals to include the new row. I am fairly new to macros and was
seeking some basic direction on how to program this.