A
Andre Ronda
I am keeping scores on a weekly basis for different persons entering as well
the date in a reference cell . In same workbook I have a range with dates
of 52 weeks trying to sum on a year-to-date basis all the scores referring
to the earlier mentioned reference cell. Whenever I entering a new
date in reference cell, it resets the all the previous data. How can I
keep the scores from earlier dates unchanged so that it only adds the new
data of the present date and giving a y-t-d sum? I think I want to make
it too complicated and maybe not seeing that there is an easier way-out.
Thnks.
Rgrds,
Andre Ronda
the date in a reference cell . In same workbook I have a range with dates
of 52 weeks trying to sum on a year-to-date basis all the scores referring
to the earlier mentioned reference cell. Whenever I entering a new
date in reference cell, it resets the all the previous data. How can I
keep the scores from earlier dates unchanged so that it only adds the new
data of the present date and giving a y-t-d sum? I think I want to make
it too complicated and maybe not seeing that there is an easier way-out.
Thnks.
Rgrds,
Andre Ronda