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