multiple sheet question

[thomasw1520]

Hello,

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

 

[GS]

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