ExcelBanter - Incrementing a worksheet number in a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Incrementing a worksheet number in a formula (https://www.excelbanter.com/excel-worksheet-functions/35470-incrementing-worksheet-number-formula.html)

[email protected]

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?

Biff

Hi!

Try this:

=INDIRECT("Sheet"&ROW(A1)&"!A1")

Biff

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?

All times are GMT +1. The time now is 06:38 AM.