2 Worksheets

[Guest]

How do you take a figures from one work sheet, and then use it in a formula on another work sheet?

 

[JulieD]

Hi Maria

when construction your formula on the second sheet
for example
=A1 +

just click on the first sheet when you want to reference it and click on the
cell that you want to use and then carry on typing your formula

it will end up looking something like this

=A1 + Sheet1!A1

Cheers
JulieD

How do you take a figures from one work sheet, and then use it in a

formula on another work sheet?

 

[Frank Kabel]

Hi Maria
one way:
- click in your target cell and enter the equation sign '='
- now select with your mouse the cell from the other worksheet
- now enter the rest of your formula

or a manual entry, e.g.
='sheet2'!A1 + A2
add the cells A1 from sheet 1 and the cell A2 from the active sheet

 

[Ben]

Maria,

I do it basically the same way I would do it if it were
in the same workseet. If you use, =, or vlookup etc.
simply have the list or pointers point to the other
file. To do this it is easy if you have both worksheets
open at the same time. If you are in sheet 1 and type =
in a cell then with your mouse highlight the cell in the
other worksheet that you want to pull it will enter the
path for you.

Ben

-----Original Message-----
How do you take a figures from one work sheet, and then

use it in a formula on another work sheet?