Pasting Functions by 5's

[MurcksPoms]

Hi everyone! I have a quick question!!

I need to paste a function, a reference to another sheet in my workbook, (=WebEntry!A1).

But when I paste to the next cell it goes up by 1. Like A1, A2, etc.
I need it to go up in increments of 5, like A1, A6, A11, A16, etc.

How can I do that?

Thanks so much!! Jennifer

[mfegyver]

do u want a code (macro) or simply pasting?
if u wanna a code, use step: for myvar = 1 to 60 step 5

[Bob Phillips]

=INDIRECT("WebEntry!A"&ROW(A1)*5-4)

[MurcksPoms]

Oh wow!! You guys are awesome!!!!
Thank you so much!!!
:yay :hifive: :yay