basic question!!!

  • Thread starter Thread starter sylvain
  • Start date Start date
S

sylvain

Hello,

I have a simple question, I tried to look in help but no
result.
Here is my problem I want to take a value from another
worksheet.

display cell's value from another worsheet.

Thanks

for email jst add .com
 
With both worksheets open, in the cell you want to have pointing to other
worksheet, type = then click on the cell in the other worksheet that you
want to reference to and hit enter. That will link those two worksheets
together.
HTH,
Dan
 
Hi,

If I understand you correctly, then one way :-

Say you want the value in Sheet1, D5 to appear in Sheet2

In Sheet2

=Sheet1!D5

The easy way is to enter = in the cell you want on the first sheet, then go
to the cell on the sheet you want it to link to and hit 'Enter' The ! sign
will appear automatically,

HTH

Alan.
 
1. Open both worksheets
2. Click on the cell you want the answer to appear in
3. Press =
4. Navigate to the other spreadsheet - probably using the windows menu
5. Click on the cell you want to get the value from
6. Press enter

HTH

Geoff
 
Hello Sylvan,

If it is simply a value from a workbook, you could use copy and paste from
one workbook to another. However, if the value you wanted was produced by a
formula, you could still use copy/paste commands, although after copying the
value (formula) you would use Edit Paste Special, and chooose value in the
other workbook.

You could also use a formula such as ='[Excel Formulas.xls]Excel
Formulas'!$D$25 from the workbook you wanted the value in, now, this is
known as external referencing, and would change if the cell from Excel
Formulas.xls file were changed, or deleted.


Hope this helps.
Paul
 
Back
Top