Using drag tool to create periodically increasing formula.

[teejaydubya]

Afternoon all,

Apologies for what is probably a very simple question, but I've been unable to find the answer anywhere - though perhaps I'm simply asking it incorrectly!

Regardless, my question is as follows:

I am trying to create a quick means of copying specific data from cells to elsewhere on the same sheet - I thought this would be possible just by typing a few examples then using the drag tool to extrapolate what I'm looking to do (increase by 14 each time), but it isn't working cause I'm using a formula, I think...

In short, I'm looking to copy data as follows:

=D32
=D46
=D60
... etc. However, Excel isn't picking up the pattern of increasing 14 cells each time.

Again, I apologise for my ignorance. I'm very new to Excel and trying to learn.

Thank you in advance for the assistance!

Tom

 

[Snakehips]

@teejaydubya You could perhaps try

=OFFSET(D32,13*(ROWS(D$32:D32)-1),0)

and drag that down.

 

[teejaydubya]

@Snakehips - thank you very much. I'd previously been entering this information manually and what previously took 15 minutes was now done in 2 seconds. Thank you again, I owe you a tea!