| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 ------------------------------------------------------------------------ macgilgamesh's Profile: http://www.excelforum.com/member.php...o&userid=27930 View this thread: http://www.excelforum.com/showthread...hreadid=474264 |
|
#2
|
|||
|
|||
|
"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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
thanks guys.. worked like a charm. -- macgilgamesh ------------------------------------------------------------------------ macgilgamesh's Profile: http://www.excelforum.com/member.php...o&userid=27930 View this thread: http://www.excelforum.com/showthread...hreadid=474264 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a Single Cell total from Seperate sheets | Excel Worksheet Functions | |||
| Sum of 3 nos. into 1 cell in another sheet relevant to specific da | Excel Discussion (Misc queries) | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
