Probably Impossible, but worth a try ;)

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)
Slide1-2-1-1.jpg


Thanks in Advance!!
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top