ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Total multiple worksheets into totals worksheet (https://www.excelbanter.com/excel-worksheet-functions/128656-total-multiple-worksheets-into-totals-worksheet.html)

David

Total multiple worksheets into totals worksheet
 
I have a workbook with 13 worksheets in it, Jan - Dec and a totals
worksheet, I need to get the ammount from;

Jan D3 and place it in Totals B3
Feb D3 - Totals C3
Mar D3 - Totals D3
etc.

Thanks in advance, David


Bob Phillips

Total multiple worksheets into totals worksheet
 
Just set up the formulae in Totals

B3: =Jan!D3
C3: =Feb!D3
etc.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"David" wrote in message
...
I have a workbook with 13 worksheets in it, Jan - Dec and a totals
worksheet, I need to get the ammount from;

Jan D3 and place it in Totals B3
Feb D3 - Totals C3
Mar D3 - Totals D3
etc.

Thanks in advance, David





All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com