ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to add totals in one sheet to another sheet (https://www.excelbanter.com/excel-discussion-misc-queries/54500-how-add-totals-one-sheet-another-sheet.html)

k.floyd

How to add totals in one sheet to another sheet
 

How do I add cells in one sheet to cells in another sheet in the same
workbook?
For example:
Sheet one name is draw 1.
Sheet two name is draw 2.
I want to copy totals in D4 in sheet one to sheet two d4.

Thanks for your help.

Katie


--
k.floyd
------------------------------------------------------------------------
k.floyd's Profile: http://www.excelforum.com/member.php...o&userid=28677
View this thread: http://www.excelforum.com/showthread...hreadid=483529


Search33

How to add totals in one sheet to another sheet
 
D4 on Draw 2 should be

='Draw 1'!D4

- Search

"k.floyd" wrote:


How do I add cells in one sheet to cells in another sheet in the same
workbook?
For example:
Sheet one name is draw 1.
Sheet two name is draw 2.
I want to copy totals in D4 in sheet one to sheet two d4.

Thanks for your help.

Katie


--
k.floyd
------------------------------------------------------------------------
k.floyd's Profile: http://www.excelforum.com/member.php...o&userid=28677
View this thread: http://www.excelforum.com/showthread...hreadid=483529




All times are GMT +1. The time now is 01:30 PM.

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