Thread: Cell Total shown Sheet to Sheet

Question:

I have an expenses/income report that is setup as a monthly sheet... Can the final Monthly total (say it is in cell AF70) be reflected from Sheet one into Sheet 2 (into cell AF 68)?? Basically, the AF70 cell in every sheet should be refelcted into the next sheets cell AF68...

Rinse and repeat for every sheet inthe excel file (12 sheets in all).

Thanks for any comments or help...
macgilgamesh

"macgilgamesh" wrote:

>
> Question:
>
> I have an expenses/income report that is setup as a monthly sheet...
> Can the final Monthly total (say it is in cell AF70) be reflected from
> Sheet one into Sheet 2 (into cell AF 68)?? Basically, the AF70 cell in
> every sheet should be refelcted into the next sheets cell AF68...

in sheet2 AF68 type =Sheet1!AF70 and so on throughout the workbook.

Regards
Peter

macgilgamesh

Select cell AF68 in Sheet 2, type '=' (equals without the quotes).
Click the sheet 1 tab, select AF70, click the green checkmark
next to the Formula bar, this should return you to sheet 2,
cell AF68 should now be populated with sheet 1 AF70.

Rinse and repeat as necessary!

George Gee


macgilgamesh wrote:
> Question:
>
> I have an expenses/income report that is setup as a monthly sheet...
> Can the final Monthly total (say it is in cell AF70) be reflected
> from Sheet one into Sheet 2 (into cell AF 68)?? Basically, the AF70
> cell in every sheet should be refelcted into the next sheets cell
> AF68...
>
> Rinse and repeat for every sheet inthe excel file (12 sheets in all).
>
> Thanks for any comments or help...
> macgilgamesh

thanks guys.. worked like a charm.