Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
workbook question
Hi!
If have a workbook with 4 sheets. 1st sheet named total and each sheet after 1..2..3... I have an amount in each worksheet 1,2,3 in cell a1 that I want to add together in a cell on the total sheet I know that you could put in =sum(1!a1+2!a1+3!a1) in a cell on the total sheet and you would get the totals for all three sheets ... but here's the question - is there anyway you could right the formula to pick up any future sheets that you would add to the workbook without having to change the formula on the total sheet? kind of like an infinity type of thing? -- as always you help is greatly appreciated!!! Jackie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
question about formula based on another workbook info | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) |