How Do I Make a Summary Page w/in Spreadsheet?

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

Example: Spreadsheet has a page for each year (2000,
2001, 2002, 2003, 2004) - each page contains same # of
columns and same titles. How do I take all the pages and
make one ongoing summary page of all data - one which
updates from the year page?

Is this what a pivot sheet does?

TYIA
 
Joanne said:
Example: Spreadsheet has a page for each year (2000,
2001, 2002, 2003, 2004) - each page contains same # of
columns and same titles. How do I take all the pages and
make one ongoing summary page of all data - one which
updates from the year page?

Is this what a pivot sheet does?

TYIA
Click to expand...
 
copy and paste
Click to expand...
Hi,

The easiest way to do this is to add an extra sheet to your workbook and
name it summary. you can copy the column headings and titles of one of the
earlier worksheets. Then total up each sheet in the summary columns. Help
shows how to do it. I use summary sheets for some accounts and they are a
breeze.

bye

Darlene
 
Back
Top