Thanks very much for your replies.
Fareastdriver; I may have not quite got it right, but trying what you suggest will not remove data which is more than a year old, if I enter data weekly. Is there any way I can programme excel to only add the rolling last 52 entries?
Thanks again