View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy_jm Andy_jm is offline
external usenet poster
 
Posts: 1
Default Automatic Formula Update

I have an Excel 2003 spreadsheet with a column of figures to which I add 2
figures daily. I have a second column showing the daily average. The
difference between the last average and the first appears in a seperate cell.
However I have to update this cell manually. I'm wondering if anyone knows
how to automate this calculation so that it updates whenever I add a new
figure to the original column?