Microsoft Excel Question

[techtonics]

I am using Microsoft Excel to keep track of my departments finances. I have created separate worksheets for each month. However, I have one worksheet that keeps track of the entire year. How do I organize my worksheets so that each time something is modified in an individual month, the changes are also reflected in the yearly worksheet? I know this is a simple question, and I hope it has a simple answer. I perused through the Help file but had no luck with a simple answer. Thanks in advance for any help.

 

[Raincity]

If its all in the same workbook then just function the year page cells to point to the monthly totals cells for the sum. If the yearly is in a different workbook then open all the workbooks at the same time and do the same process and the year workbook will link itself to all the monthly workbooks and look for changes when you open it.

 

[NeoV]

tech, you have a few options...

a simple way would be to have the exact same format on each worksheet....for example.....column 1, row 1, would always be the department name...say "finance"....col 2 row 1 would be the expense for that account/month..

so on worksheet 2, you have the exact same format.....and this repeats for all 12 worksheets you have....so on your "entire year" worksheet, you have a formula that says "=+ws1:b1+ws2:b2..etc etc..."

A better way to do it would be to have a seperate column for each month, all on the same worksheet...then you just have sum formula at the end of the row for each department.

 

[techtonics]

Thanks for the help guys, I was able to accomplish what I wanted to do.