Cell Total shown Sheet to Sheet

[macgilgamesh]

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

 

[PeterAtherton]

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

 

[George Gee]

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]

thanks guys.. worked like a charm.