Coping forumalted answers

[Waby]

Hello, This might be a silly question, but i cant figure it out

When copying data from one one sheet to another, the first being celling an
answer to a forumla, on the second sheet i get the value. If i change the
forumla on sheet 1, the value on sheet two does not change. How do i copy
the cell that no matter what i change in sheet 1, the current answer in sheet
1 will copy over to sheet two? Am i explaining my self correctly?

Thanks

 

[Mike H]

Hi,

To do that you don't copy the formula, you refer to it. For example say we
have this formula in A1 of sheet 1

=22/7

On sheet 2 you can have this formula

=Sheet1!A1

Now whenever sheet1 a1 changes so does the value in sheet 2.

Mike