View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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.