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?
|