autofill according to cell index.
 

for example I fill B1 cell with D3.And I want to fill the other B
cells(B2,B3...) with the D(3+n) .The n is a constant.For example n=2. That is
why B2=D5 or B3=D7.How can I do that??Thank you

Hi
in B1 enter
=OFFSET($D$3,(ROW()-1)*n,0)

--
Regards
Frank Kabel
Frankfurt, Germany

"honour" schrieb im Newsbeitrag
...
for example I fill B1 cell with D3.And I want to fill the other B
cells(B2,B3...) with the D(3+n) .The n is a constant.For example n=2.
That is
why B2=D5 or B3=D7.How can I do that??Thank you