Fill handle not working for cell references

[Murdoch07]

Hello,

I want to fill a column of cells with a reference that points to a cell in another worksheet. The key - I want every cell in the host sheet to reference every third cell in the other sheet. For example,
A1=D3
A2=D6
A3=D9
A4=D12....

This must be done for thousands of records. Unfortunately, when I use the fill handle to drag the formula down, the correct number is not done. Instead, I get this (after selecting the first 4 cells that were manually entered):
A5=D9 => should be D15
A6=D10 => should be D18
A7=D13 => should be D21
A8=D16 => should be D24
...
Any suggestions on why this may be happening, or other routes to take?

Thanks

 

[Jerry Sullivan]

Hello and Welcome,

You could try...

Enter into Sheet1!A1 and copy down.
=OFFSET(Sheet2!D$1,ROW(A1)*3-1,0)

 

[Murdoch07]

That's it... thanks!

 

[RoryA]

If it's just a one-off, you can also enter:
zzD3
zzD6

then fill those two down and replace zz with =