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?

Enter the values 2 through 31 in cells A2 through A31 ...
Then put this formula in B2
=INDIRECT("'"&A1&"'!$A$1")
Then copy down column B to row 31.
Rgds,
ScottO

wrote in message
oups.com...
| 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?
|