Copy Data from Within same Workbook

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
 
P

Pete_UK

Put this in B4:

=INDIRECT("'Sheet"&ROW(A1)&"'!E8")

and then copy down. No need for the SUM function.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top