look back period

[Scorpion]

every week, once a week a get new data, i have 10 years of data on 27
different brands. i have to calculate a 1, 3, 5, 10 year averages, maximum,
minimum, calculations, for every week from the latest week to the oldest so i
add the latest week to the spreadsheet and delete the oldest week data, all
manualy, is there a way i can create a formula to do this for me automaticaly


scorpion

 

[Per Jessen]

Sure it can be done by a macro.

As a start use the Macro Recorder to record what you are doing manually.

Then post the code to get help adjusting the macro to work with new data
each week.

Regards,
Per