I have detailed data that needs to be rolled up to a summary page reflecting the total of the data.
M Millard Oct 3, 2006 #1 I have detailed data that needs to be rolled up to a summary page reflecting the total of the data.
M Millard Oct 3, 2006 #4 No I haven't tried a Pivot table, is that easy to do, and where do I go to get the steps? Thanks,
M Millard Oct 3, 2006 #5 I'm sorry I don't know what that is, would I have to create a new tab and/or spreadsheet? Thanks,
B BFC Oct 3, 2006 #6 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.
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.
M Millard Oct 3, 2006 #7 That's it! Thank you for the wonderful, quick help. Got my report done on time! all the best!