Excel Help
Im trying to auto fill a formula that gathers info from other cells, but is not a fixed cell. I need it to increase by eight cell numbers at a time. like here
=CELL(“contents”,Sheet1!$E6)
=CELL(“contents”,Sheet1!$E14)
=CELL(“contents”,Sheet1!$E22)
=CELL(“contents”,Sheet1!$E30)
=CELL(“contents”,Sheet1!$E38)
but when I auto fill comes out like this
=CELL(“contents”,Sheet1!$E6)
=CELL(“contents”,Sheet1!$E14)
=CELL(“contents”,Sheet1!$E22)
=CELL(“contents”,Sheet1!$E30)
=CELL(“contents”,Sheet1!$E38)
=CELL(“contents”,Sheet1!$E11)
=CELL(“contents”,Sheet1!$E19)
=CELL(“contents”,Sheet1!$E27)
=CELL(“contents”,Sheet1!$E35)
=CELL(“contents”,Sheet1!$E43)
=CELL(“contents”,Sheet1!$E16)
=CELL(“contents”,Sheet1!$E24)
=CELL(“contents”,Sheet1!$E32)
=CELL(“contents”,Sheet1!$E40)
=CELL(“contents”,Sheet1!$E48)
=CELL(“contents”,Sheet1!$E21)
=CELL(“contents”,Sheet1!$E29)
any help would be appreciated.