formula construction
 

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?

formula construction
 

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

formula construction
 

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 ("")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Old Red One" wrote in message
...
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?

formula construction
 

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

formula construction
 

The cells are on separate Pages, not Sheets, in the same document. Can
Excel handle that? Please comment. Thank you.
"Max" wrote in message
...
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 ("")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Old Red One" wrote in message
...
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?

formula construction
 

"Old Red One" wrote in message
...
The cells are on separate Pages, not Sheets, in the same document. Can
Excel handle that? Please comment. Thank you.

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).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

formula construction
 

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

formula construction
 

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

formula construction
 

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