View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
terry freedman terry freedman is offline
external usenet poster
 
Posts: 16
Default adding cells of workbooks not yet created

That's brilliant, Tom

Thanks!

Terry

On Fri, 22 Oct 2004 07:02:19 -0400, "Tom Ogilvy"
wrote:

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.


==
Terry Freedman
For articles on e-learning and ICT, and to subscribe to Computers in Classrooms, visit http://www.ictineducation.org