View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default automation of YTD calculation

How is your data set up? column references, row references, where new data
would be entered, and what is your current YTD formula?
--
** John C **

"MPP" wrote:

How can I automate a YTD calculation ?I have my data from january to
september and my YTD column. When I insert a column for october I have to
update the formula to calculate the YTD.