Complex excel issue:?
Complex excel issue: I have a worksheet that holds daily value in separate cells which are the categories. In those cells the number will change daily but I am trying to get the daily cells to feed into the weekly/monthly/yearly worksheets without losing the value from the previous day. For example the weekly worksheet had cells that hold value from the daily but the weekly is broke into day cells. How would I differentiate the days of week from the continuous changing daily value and so forth?
Be the first to answer this question.