View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Newbee Newbee is offline
external usenet poster
 
Posts: 33
Default Dynamic reporting rolling averages

I have a report that I want to dymaically report a rolling average.
For instance.

Jan = 15 wich is pulled from worksheet B on another share drive.
Feb = Jan 15 previous months total + 20 which is pulled worksheet B again.
March =....

Can I make this happen without having to add copy and paste?