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

[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

 

[Don Guillett]

Pls do NOT multi post cuz those that would respond generally read all.

 

[Babs]

copy and paste

 

[Babs]

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

 

[Darlene Kupke]

copy and paste

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