Thread
:
Incrementing a worksheet number in a formula
View Single Post
#
1
[email protected]
Posts: n/a
Incrementing a worksheet number in a formula
I have a workbook with 31 worksheets. I want to use the formula
=Sheet2!$a$1 and be able to drag it down with the sheet number
incrementing to =sheet31!$a$1. Is there a way to do this?
Reply With Quote