automatic copy of results to another page
 

I am creating a yearly expense sheet with per month each page and a summary
sheet with monthly totals
How can I set it up so when results for monthly totals are created on the
month page they also appear on the yearly summary page?

automatic copy of results to another page
 

One way of many
=sheet2!a2
where a2 in sheet 2 has the total for the month.

--
Don Guillett Excel MVP
SalesAid Software

"chris quinn" <chris wrote in message
...
I am creating a yearly expense sheet with per month each page and a summary
sheet with monthly totals
How can I set it up so when results for monthly totals are created on the
month page they also appear on the yearly summary page?