Try saying that again with more detail about how the data is set out in the
files
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Newbee" wrote in message
...
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?