I need to copy and a paste a formula that will calculate the same thing
for a large amount of data. My problem is I don't know how to copy a
formula so that it will use the cells I need it to. My original formula
is something like, (O3+O4*3)/4 and when I copy it down to the next line
excel will make the formula (O4+O5*3)/4. What I need to know is how to
make it skip to (O5+O6*3)/4, then the next line down (O7+O8*3)/4, then
(O9+O10*3)/4 and so on.


--
Tom.
------------------------------------------------------------------------
Tom.'s Profile: http://www.excelforum.com/member.php...o&userid=33766
View this thread: http://www.excelforum.com/showthread...hreadid=535370