How do I reference a value to consecutive merged cells

[Johnhod]

How do I reference a value to consecutive merged cells ( 6 cells merged in a
single column, repeated 8 times downwards) from single unmerged cells in a
column in a different worksheet? If I manually reference e.g ='Schedule &
Billing'!D9 in the first cell then use the handle bottom right crnr of cell
to drag formulae, instead of getting the next cell in the source series,
='Schedule & Billing'!D10 it gets ='Schedule & Billing'!D9 plus 6 ='Schedule
& Billing'!D15. Note that 6 is the number of row/cells merged to make one in
the destination column.

 

[Pete_UK]

Try it this way:

=INDIRECT("'Schedule & Billing'!D"&(ROW(A1)*6+3))

and then copy this down.

Hope this helps.

Pete