look back period
 

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

look back period
 

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

"Scorpion" skrev i meddelelsen
...
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