put in 3 new blank sheets
Name the first First
Name the second Last
Name the third Master
in Master put in the formula
=Sum(First:Last!G1)
now move all your expense sheets between sheets First and Last in the tab
order. When you create a new one, put it between first and last.
--
Regards,
Tom Ogilvy
"terry freedman" wrote in message
...
Hi
Every time I do some work I create a spreadsheet containing details of
the expenses incurred. The total is always in cell G1. Is it possible
to create a master spreadsheet that will automatically add up all the
G1 cells without my having to update the formula each time I create a
new expenses spreadsheet?
TIA
Terry
==
Terry Freedman
For articles on e-learning and ICT, and to subscribe to Computers in
Classrooms, visit
http://www.ictineducation.org