| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incrementing a worksheet number in a formula | Excel Worksheet Functions | |||
| Transform a Cell from Formula to Number | Excel Discussion (Misc queries) | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
| incrementing formula reference by 7 | Excel Discussion (Misc queries) | |||
| Write formula to add "1" to each number in a column | Excel Worksheet Functions | |||
Linear Mode
