formula construction

O

Old Red One

What is the formula that causes a cell to update based on a change in data
in a cell on a different page, albeit a page in the same document?
 
F

flummi

If you select "automatic" on the calculation tab of the options page
Excel performs a recalc everytime a value is changed somewhere! If you
select "manual" the sheet is never recalculated until you press F9.

Was that your question?

Hans
 
M

Max

Perhaps you're looking for a simple link formula ?

Placed in any cell in say, Sheet2, eg in B2:
=IF(Sheet1!A1="","",Sheet1!A1)
will return what's in Sheet1's A1

And if Sheet1's A1 is empty (or contains a formula which may evaluate to:
""),
then Sheet2's B2 will also appear blank ("")
 
P

Pete

I think the formula would be something like:

=Sheet1!A1

if the data that changed was in cell A1 of Sheet1.

Hope this helps.

Pete
 
O

Old Red One

The cells are on separate Pages, not Sheets, in the same document. Can
Excel handle that? Please comment. Thank you.
 
M

Max

Old Red One said:
The cells are on separate Pages, not Sheets, in the same document. Can
Excel handle that? Please comment. Thank you.
Click to expand...

But I had read it that "Pages" == Sheets ?
(and that "document" == Book)

If so, then the previous suggestion should work as it covers linking cells
in separate sheets within the same book (Sheet1's A1 linked to Sheet2's B2).
 
P

Pete

My understanding is the same as Max's, but even if you mean "pages" as
in printed pages from the same sheet, the formula would still work.

Pete
 
F

flummi

Sorry Richard, Ióst your email address.

Here's my comment:

page 5 page 6


amount $ amount $
1400 452
5000 77
2400 64
752 11437 <-- from A13: =A13
1885 90



sum of G5:G9 sum of I5:I9
11437 <-- =SUM(G5:G9) 12120 <-- =SUM(I5:I9)

Any change of a value in the page 5 range G5:G9 will change the sum in
A13 which will change the according value in the page 6 range I5:I9
which will change the sum of the page 6 values in D13.

If in this context you get wrong results it my have to do with the
autosum feature.

Please let me know if it works.

Hans
 
F

flummi

Sorry Richard, I list your email address.

Here's my comment:

page 5 page 6


amount $ amount $
1400 452
5000 77
2400 64
752 11437 <-- from A13: =A13
1885 90



sum of G5:G9 sum of I5:I9
11437 <-- =SUM(G5:G9) 12120 <-- =SUM(I5:I9)

Any change in the "page 5" column G5:G9 will change the sum in A13 wich
will then change the value in the page 6 column I5:I9 which will
change the sum of that tange in D5.

If in this context you get wrong results it may have to do with the
autosum feature.

Let me know if it works.

Hans
 
Top