| 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Display excel formula on worksheet | Excel Worksheet Functions | |||
Threaded Mode
