Thanks Spencer.
http://rapidshare.com/share/300A83FD...1A2E730BCFD764
Well what I am asking is how would I set it up so that the box filled in red will show a running 7 day average as I will be inputting a line of data daily.
As i'm sure you can understand I had to strip out all the sensitive data.
Thanks in advance