multiple sheet 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?
|