Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Total Across Pages
I have an Excel spreadsheet that has pages 1-12, which is a two year budget
of items per category (there are 12 categories). I want to make a MASTER sheet that includes the total row of each of the 12 sheets. How do I populate the fields on the MASTER sheet from the other pages? |
#2
|
|||
|
|||
MamaHart,
Let us assume that you current sheets have tab names called 1, 2, 3.. 12. Let us also assume that the data you want exists in Row 1 and Column A, B, C (in the individual sheets). Insert a new worksheet (Insert, worksheet) Insert headings in your new sheet in row 1 and Columns A to J (if required). In Row 2, Column A enter = (equal sign) then using your mouse go to the sheet that you need to bring the data from and in the cell that has the figure you want hit enter. You should now notice that the figure from that sheet will now appear in Row 1 Column A. Repeat the above for all 12 sheets and you should have a MASTER sheet. For your information with your cursor in row 1 column A, look at the formula bar it will read something like =sheetname!cell number. HTH "MamaHart" wrote: I have an Excel spreadsheet that has pages 1-12, which is a two year budget of items per category (there are 12 categories). I want to make a MASTER sheet that includes the total row of each of the 12 sheets. How do I populate the fields on the MASTER sheet from the other pages? |
#3
|
|||
|
|||
Hi
assuming that your total row in each of the 12 sheets (and by sheets you mean separate worksheets, not "printable" pages within a worksheet) is in the same place (e.g. row 20), on the master sheet you can use a formula e.g. =SUM(Jan:Dec!A20) this will add up from the sheet called Jan to the sheet called Dec everything that is in A20. (substitute your sheet names for Jan & Dec (if your sheet names have a space in them you'll have to use single apostraphe's around the names, e.g. =SUM('Mth 1:Mth 12'!A20) -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "MamaHart" wrote in message ... I have an Excel spreadsheet that has pages 1-12, which is a two year budget of items per category (there are 12 categories). I want to make a MASTER sheet that includes the total row of each of the 12 sheets. How do I populate the fields on the MASTER sheet from the other pages? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I merge total from many pages into one main page in excel? | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Total remaining formula | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
How do I delete pages? | Excel Discussion (Misc queries) |