Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
k.floyd
 
Posts: n/a
Default 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

  #2   Report Post  
Search33
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get a row consecutive from a sheet to another rodante Excel Worksheet Functions 4 October 30th 05 06:20 PM
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
Summary Sheet Totals gwhite Excel Discussion (Misc queries) 3 July 11th 05 02:28 AM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM
Find a non-blank cell and bring back text a in same row Rod Excel Worksheet Functions 12 March 24th 05 09:43 PM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"