PDA

View Full Version : Pasting Functions by 5's



MurcksPoms
12-12-2007, 08:04 PM
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
12-12-2007, 09:30 PM
do u want a code (macro) or simply pasting?
if u wanna a code, use step: for myvar = 1 to 60 step 5

xld
12-13-2007, 12:54 AM
=INDIRECT("WebEntry!A"&ROW(A1)*5-4)

MurcksPoms
12-13-2007, 10:15 AM
Oh wow!! You guys are awesome!!!!
Thank you so much!!!
:yay :hifive: :yay