Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Winnie
 
Posts: n/a
Default Copy result from sheet1 to sheet2

How to show the result(sheet 1) on sheet2 and sheet3
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Copy result from sheet1 to sheet2

"Winnie" wrote:
How to show the result(sheet 1) on sheet2 and sheet3


Perhaps you mean simple link formulas ..

In any starting cell in either Sheet2 or Sheet3 ..
Put say in, B2: =Sheet1!A1
then copy B2 across and fill down to return correspondingly from Sheet1
as may be required

Alternatively, for a neat clean look in the Sheets 2 or 3,
i.e. to avoid extraneous zeros display for any linked empty cells in Sheet1,
we could use instead in B2: =IF(Sheet1!A1="","",Sheet1!A1)
and copy across / fill down as before
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Copy result from sheet1 to sheet2

"Winnie" wrote in message
...
How to show the result(sheet 1) on sheet2 and sheet3


Click in the cell where you want the result to be displayed on sheet 2.
Type =, then go to the cell where the result is calculated on sheet 1.
Clicking there will put the reference of that cell after the = in the
formula on sheet 2. Accept that formula.
The same for sheet 3.
--
David Biddulph


  #4   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Copy result from sheet1 to sheet2

Clarification .. line
.. to return correspondingly from Sheet1


should read as
.. to return correspondingly from Sheet1's A1


Adapt the start cell's formula in B2 to point to suit to the particular
source cell in Sheet1 (I used A1 as an example)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
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 convert a number to text conman Excel Discussion (Misc queries) 2 June 8th 06 04:24 AM
I NEED HELP with the SPELLNUMBER Function vag Excel Worksheet Functions 0 June 21st 05 08:17 AM
Modifying Sheet1 macro to run on Sheet2 Sharon Excel Discussion (Misc queries) 6 April 28th 05 01:21 PM
Copy values from Sheet1 to Sheet2 Eintsein_mc2 Excel Discussion (Misc queries) 1 January 6th 05 06:02 AM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 08:32 PM


All times are GMT +1. The time now is 10:41 AM.

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"