Copying a formula and skipping lines

[Stephen Rammer]

I have a formula which contains two cells which are not
adjacent. (E14/E20). I want to copy this formula so it
skips 6 lines for every time I copy the formula downwards
in the spreadsheet...e.g. (E20/E26), (E26/E32) etc...

Is there any smart way to do this or will I have to do
this manually?

Thanks alot
Stephen

 

[Frank Kabel]

Hi Stephen
assuming your formula starts in F1 (result should be E14/E20 for F1)
insert the following in F1:
=INDIRECT("E" & (ROW()-1)*6+14) / INDIRECT("E" & (ROW()-1)*6+20)
copy down

HTH
Frank