Creating an ongoing summary sheet within Spreadsheet

  • Thread starter Thread starter JS
  • Start date Start date
J

JS

I have a spreadsheet with tabs for 2000-2001, 2002, 2003,
2004. All formats are same. How do I make a page for
totals of all these pages - is this how a pivot table
would work?

Thanks!
 
It depends on what form the information is on the your sheets. If the
information is in a data table with the first line being a header row then
you can create pivot tables for each table.
Gary
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LOOKUP within a 1
LOOKUP function between two dates in Excel 2007 6
How Do I Make a Summary Page w/in Spreadsheet? 4
Pivot Tables with Multiple Lists 2
Lock location of sheet within a spreadsheet 4
Pivot Tables Question with Excel 2000 2
Pivot tables - All Change with Validation List 1
Update Summary Sheet Automatically 7

Back
Top