Copying a cell formula to several cells below but only wanting the formula to move one cell?

[Peter Davison]

I have a formula in one cell in a column in Sheet1 (e.g. Cell C3)
The formula in the cell is ='Sheet2'!H15
I want to copy the formula from Cell C3 to Cell C15, but I only want the formula to move one cell
so I want the formula to be ='Sheet2'!H16
Is there a way of doing this?

 

[FormR]

Hi, you could give this formula a try.

=INDEX(Sheet2!$H$15:$H$1000,ROUNDUP(ROWS(C$3:C3)/12,0))

 

[Peter Davison]

Thanks for coming back to me.
I tried the formula but excel kept locking up, not sure why.
Any other thoughts?
I have found a temporary solution by entering the row number in a column and using indirect to do the formula.

 

[FormR]

I tried the formula but excel kept locking up

Hi, it's working my end, which might suggest it's a problem with your set-up / workbook - did you alter the suggestion at all?

Even so, I can't imagine there's anything in the suggestion that could cause Excel to crash.

Book8
	C
3	A
4
5
6
7
8
9
10
11
12
13
14
15	B
16
17
18
19
20
21
22
23
24
25
26
27	C
Sheet1

Cell Formulas
Range	Formula
C3,C27,C15	C3	=INDEX(Sheet2!$H$15:$H$1000,ROUNDUP(ROWS(C$3:C3)/12,0))

Book8
	H
15	A
16	B
17	C
18	D
19	E
Sheet2

 

[Peter Davison]

Apologies for not saying. I've had to look at it a different way.
Yes I did change it so it would work with a different spreadsheet
What I have now is the following

I have a formula in one cell in D column in Sheet called (Master) (e.g. Cell D67)
The formula in the cell is ='Sheet1'!B1276
I want to copy the formula from Cell D67 to Cell D68, but I want the formula to move 44 cells
so I want the formula to end up ='Sheet1'!B1320

and then be able to repeat as many times as needed.

Thankyou if you can help.

 

[FormR]

You could try this in D67 of the master sheet copied down.

=INDEX(Sheet1!$B$1276:$B$9999,((ROWS(D$67:D67)-1)*44)+1)

 

[Peter Davison]

That worked perfect, thank you so much for your time and patience
Regards