deleriumbliss
New Member
- Joined
- Oct 1, 2008
- Messages
- 6
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!!
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!!