Put 1 in A1 of Sheet1

Then...

=sheet1!a1+1
in A1 of Sheet2

=sheet2!a1+1
in A1 of sheet 3

.....


s6292 wrote:

what if I have multiple sheets in a workbook and I want a number in a cell to
increase by 1 on each consecutive worksheet?

"Dave Peterson" wrote:

=sheet1!a1+sheet3!b99+'sheet 999'!x99
or
=sum(sheet1!a1,sheet3!b99,'sheet 999'!x99)



s6292 wrote:

How do I add cells together from different sheets within a workbook

--

Dave Peterson


--

Dave Peterson