Hello,

I have a workbook with multiple sheets worth of values that change by day. The sheets are labeled Day, Week, Month, Quarter, Year etc. My issue is that I would like to create a function that takes values from the Day sheet and forwards it to the other sheets. I do not mean the SUM function because if I change the Day value the following values will also change. Is there any function that will act as a additive function such that when I insert a new value for Day it will add to the previous values in the week, month and so on?

thomasw1520 formulated the question :
Hello,

I have a workbook with multiple sheets worth of values that change by
day. The sheets are labeled Day, Week, Month, Quarter, Year etc. My
issue is that I would like to create a function that takes values from
the Day sheet and forwards it to the other sheets. I do not mean the SUM
function because if I change the Day value the following values will
also change. Is there any function that will act as a additive function
such that when I insert a new value for Day it will add to the previous
values in the week, month and so on?

This would be a trivial task if all the data was on a single sheet that
is *structured* to consolidate values by weeks/months/quarters/year
based on entry of a date. Use of outlining would make for a very
efficient, professional looking model <IMO!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion