View Single Post
  #1   Report Post  
thomasw1520 thomasw1520 is offline
Junior Member
 
Posts: 1
Default 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?