fill question

J

John M

Hi,

I want to somehow automatically increment cell references. It would be
easier to explain with an example. In my worksheet, i want to list all the
all the summary turnovers in my Turnover worksheet. For the first cell,
Turnover!D7 is what i want, Turnover!D14 is for the second cell, Turnover!D21
is for the third cell and etc. If i use the normally fill function by holding
right corner and dragging i will get Turnover!D8 for second cell, Turnover!D9
for third cell and etc.

Could someone enlighten me. It is so frustrating to always add 7 to the
previous cell reference.

Thanks in advance.
 
J

John Green

Try the following formula in your first cell.

=OFFSET(Turnover!$D$7,(ROW(A1)-1)*7,0)

When copied down it will produce the pattern you need.

John Green
 
Top