Posted by Nigel Addison on October 17, 2001 5:03 AM
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!