MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Worksheets


Posted by Nigel Addison on October 17, 2001 5:03 AM

Dear All,

I've created a workbook with the 12 months of the year as individual worksheets, within the worksheets I have broken the information down to daily/weekly info! formulas have been created to totalise specific data.

What I'm trying to do is the following -
I have created a 13th worksheet for yearly activity which will show monthly figures, so I can compare performance against ea month! How on earth do I create a formula that will allow me to to transpose the data from ea worksheet to the the 13th worksheet, so that inturn will create further calcu;lations!!

It would be great if you could help!

Regards

Nigel


Posted by Dan on October 17, 2001 5:11 AM

Forgive me if I don't understand, but are you just looking for syntax? If you wanted to, say, add cell A1 from the "January" worksheet to A1 from the "February" worksheet, then your formula on your "Year End" worksheet would be:

=January!A1+February!A1

HTH. Post back if this isn't what you meant.

Posted by lenze on October 17, 2001 5:53 AM

You might check out using Data>Consolidation. Here's an address of an article to get you started.

http://www.woodyswatch.com/office/archtemplate.asp?v6-n37