Probably Impossible, but worth a try ;)

[deleriumbliss]

Hello all! I have (to me) a difficult (if impossible) function.

I have 5 sheets (each sheet is a week) of weekly performance. Each row has a different person, each column a different performance value. I do this by sheet, because each week, I need to print that particular week.

At the end of each week, I have their performance in EACH column transferred to the MONTH END sheet (which also needs to be printed each month).

I also have to have a quarterly sheet with each separate person's (weekly numbers), THREE months running. I would like to keep it all within the same document, if possible; updating the month and quarter each time I enter the week numbers.

Is there an EASY way to do this, where I only need to enter the data ONCE and have it automatically transfer to Month and Quarter?

Here is the first row's data (For week 1)

Thanks in Advance!!

 

[deleriumbliss]

I figured something out. Thanks!