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
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