Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding cells of workbooks not yet created
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding cells of workbooks not yet created
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding cells of workbooks not yet created
The simplest way is to keep all your spreadsheets in one workbook, each on a
different sheet. Name the workbook a descriptive name for the jobs you have done in a certain period of time, for example "2004Jan_Mar.xls" and create enough blank sheets to enter your jobs for that period. Make sheet1 your Totals sheet and put a formula on it to Sum G1 on all other sheets. Mike F "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding cells of workbooks not yet created
Thanks very much, Mike
On Fri, 22 Oct 2004 12:04:19 GMT, "Mike Fogleman" wrote: The simplest way is to keep all your spreadsheets in one workbook, each on a different sheet. Name the workbook a descriptive name for the jobs you have done in a certain period of time, for example "2004Jan_Mar.xls" and create enough blank sheets to enter your jobs for that period. Make sheet1 your Totals sheet and put a formula on it to Sum G1 on all other sheets. Mike F "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 == Terry Freedman For articles on e-learning and ICT, and to subscribe to Computers in Classrooms, visit http://www.ictineducation.org |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding cells of workbooks not yet created
Can you do this with sumif too?
"Tom Ogilvy" skrev: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A series created with data in two workbooks | Charts and Charting in Excel | |||
Adding like cells from different workbooks | Excel Worksheet Functions | |||
How do I use a micro created in one workbook in other workbooks? | Excel Worksheet Functions | |||
Adding cells from multiple workbooks | Excel Discussion (Misc queries) | |||
Open/manage newly created workbooks | Excel Programming |