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.