Thread
:
automatically apply formula to new row
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett