# change excel - Automatically increment sheet reference when dragging formula

0
Answers

cell name dynamic

I have a formula with the following syntax:

```
=SheetName!E10
```

and need some way to drag the formula and change just the sheet name as it moves to the right. So the `E10`

part needs to stay the same with the sheet number incrementing as I drag the formula. We have many rows and columns to do and this would definitely speed us up.

Is this possible?

So the result would look like this:

```
=Sheet1!E10 =Sheet2!E10 =Sheet3!E10
```

This is the result:

from applying this formula:

```
=INDIRECT("mo"&COLUMN()+0&"!B4")
```

0 votes