| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do the details in an excel spreadsheet move to a summary page
I have detailed data that needs to be rolled up to a summary page reflecting
the total of the data. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do the details in an excel spreadsheet move to a summary page
Something like =SUM(Sheet1:Sheet2!A1) ?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Millard" wrote in message ... I have detailed data that needs to be rolled up to a summary page reflecting the total of the data. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do the details in an excel spreadsheet move to a summary page
Have you tried a PivotTable?
"Millard" wrote: I have detailed data that needs to be rolled up to a summary page reflecting the total of the data. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do the details in an excel spreadsheet move to a summary p
No I haven't tried a Pivot table, is that easy to do, and where do I go to
get the steps? Thanks, "BFC" wrote: Have you tried a PivotTable? "Millard" wrote: I have detailed data that needs to be rolled up to a summary page reflecting the total of the data. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do the details in an excel spreadsheet move to a summary p
I'm sorry I don't know what that is, would I have to create a new tab and/or
spreadsheet? Thanks, "Bernard Liengme" wrote: Something like =SUM(Sheet1:Sheet2!A1) ? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Millard" wrote in message ... I have detailed data that needs to be rolled up to a summary page reflecting the total of the data. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do the details in an excel spreadsheet move to a summary p
I would refer to Excel Help on this. They're fairly easy to create, and
Excel has a built in Wizard to help you create the PivotTable. If you want to jump right in, go to Data, Pivot Table and Pivot Chart Report. It should walk you right through it. "Millard" wrote: No I haven't tried a Pivot table, is that easy to do, and where do I go to get the steps? Thanks, "BFC" wrote: Have you tried a PivotTable? "Millard" wrote: I have detailed data that needs to be rolled up to a summary page reflecting the total of the data. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do the details in an excel spreadsheet move to a summary p
That's it! Thank you for the wonderful, quick help. Got my report done on
time! all the best! "BFC" wrote: I would refer to Excel Help on this. They're fairly easy to create, and Excel has a built in Wizard to help you create the PivotTable. If you want to jump right in, go to Data, Pivot Table and Pivot Chart Report. It should walk you right through it. "Millard" wrote: No I haven't tried a Pivot table, is that easy to do, and where do I go to get the steps? Thanks, "BFC" wrote: Have you tried a PivotTable? "Millard" wrote: I have detailed data that needs to be rolled up to a summary page reflecting the total of the data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy page breaks within an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel Spreadsheet with Autofilters as a Web Page | Excel Discussion (Misc queries) | |||
| How do I get a Control Button in Excel to move down the page when. | Excel Discussion (Misc queries) | |||
| excel 2003 page numbering | Excel Worksheet Functions | |||
Linear Mode
