Hi, somewhat new to excel.
As I am getting close to the VAT registration limit (which I DO NOT WANT no exceed) I have entered last years sales on sheet 2 and this years sales (so far) on page 1. As the VAT reg. limit is calculated on a progressive 12 monthly turnover basis, what I would like to achieve is an automatic weekly indication of the progressive 12 month turnover. That is to say, ask excel to calculate on a weekly basis what the previous 52 weeks totals, or on (perhaps) week 5, excel extracts the info from page 2 to week 6. I have no idea how to achieve this. I have an excel manual but dont know the correct terminology to use the index to find instruction. Would seriously like a little help.
Thankyou in anticipation.