F
Father John
Hi
I have a problem that I just can't seem to solve
I have a multisheet workbook and in each there are a series of results that
are located in the same cell but on different pages.
I want to bring these all onto the first Master Page.
In the first cell on the Master Page (sayB4) I type =SUM(Sheet1!E8), I then
want cell C4 to show =SUM(Sheet2!E8) but it says =SUM(Sheet1!F8) copying the
next cell it believes to be in sequence.
What am I missing??
Many thanks
Stephen
I have a problem that I just can't seem to solve
I have a multisheet workbook and in each there are a series of results that
are located in the same cell but on different pages.
I want to bring these all onto the first Master Page.
In the first cell on the Master Page (sayB4) I type =SUM(Sheet1!E8), I then
want cell C4 to show =SUM(Sheet2!E8) but it says =SUM(Sheet1!F8) copying the
next cell it believes to be in sequence.
What am I missing??
Many thanks
Stephen