Cell Total shown Sheet to Sheet

  • Thread starter Thread starter macgilgamesh
  • Start date Start date
M

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
 
macgilgamesh said:
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...
Click to expand...

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
 
Back
Top